SqlServerKudos - Latest published stories in Management

Management

atom rss
1
kudos
spam Kudos Remove

Cost Based Optimizer
published 1024 days, 4 hours, 39 minutes ago posted by sasa 1027 days, 2 hours, 36 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 2:10:06 PM GMT
Cost Based Optimizer
Last year, I started what was to be a series of articles about the SQL Server execution plan cost model, i.e., the Cost Based Optimizer (CBO). At the time, I could not upload images and an explanation without pictures is very tedious to follow. This is the same topic, except that I can now upload images, so important points are now illustrated. The coverage here includes Index S... (more)
category: Management | clicked: 0 | comment | | source: sqlblog.com
tags: Cost Based Optimizer, Performance
1
kudos
spam Kudos Remove

How to add an additional node to a SQL Server failover cluster
published 1024 days, 4 hours, 39 minutes ago posted by sasa 1027 days, 2 hours, 20 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 2:25:50 PM GMT
How to add an additional node to a SQL Server failover cluster
Sometimes a two-node cluster configuration is not enough for your SQL Server, as you may want to create new SQL instances, which will reside in a different node than the existing SQL instances. So in this case you may want to add a 3rd or a 4th node to the SQL cluster.   Assuming you already have installed a SQL Server failover instance on two nodes and you now want to add a 3rd node, the steps to perform this procedure are as follows... (more)
category: Management | clicked: 1 | comment | | source: blogs.msdn.com
tags: Failover Cluster, Node
1
kudos
spam Kudos Remove

Getting CPU Utilization Data from SQL Server
published 1024 days, 4 hours, 39 minutes ago posted by sasa 1027 days, 1 hour, 34 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:12:12 PM GMT
Getting CPU Utilization Data from SQL Server
When I installed the SQL Server Performance Dashboard for the first time, perhaps a couple of years ago, the first thing that caught my attention was the nice graph in the main screen showing the system CPU utilization. Then I immediately wanted to know where this report was getting this CPU information from. A few minutes later I found the undocumented sys.dmosring_buffers DMV... (more)
category: Management | clicked: 4 | comment | | source: sqlblog.com
tags: Performance
2
kudos
spam Kudos Remove

SQL Update Statement: How to Create a Server-Side Trace with SQL Profiler
published 1024 days, 4 hours, 39 minutes ago posted by http://sqlchicken.blogspot.com/http://sqlchicken.blogspot.com/ 1027 days, 1 hour, 24 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:22:08 PM GMT
SQL Update Statement: How to Create a Server-Side Trace with SQL Profiler
This morning on Twitter my friend (and as per request, “handsome moron”, but trust me he’s no moron) Jeremiah Peschka (Twitter) asked about scheduled traces. I suggested he do a server-side trace. Unfortunately when you Google how to do this it just tells you how to do this via T-SQL but to my dismay I didn’t see an article on how to create/set this up from SQL Server Profiler. So this will be a quick rundown on how to create your trace using the GUI of SQL Server Profiler and schedule your trace to run ... (more)
category: Management | clicked: 2 | comment | | source: sqlchicken.blogspot.com
tags: Administration, SQL Server 2005, SQL Server 2008
1
kudos
spam Kudos Remove

SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048
published 1026 days, 4 hours, 41 minutes ago posted by sasa 1026 days, 14 hours, 9 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Tuesday, July 28, 2009 2:36:37 AM GMT
SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048
SQL Server error: Msg 6101, Level 16, State 1, Line 1 Process ID -2 is not a valid process ID. Choose a number between 1 and 2048 - update Here is the quirky error that has caused a resources crunch on a SQL instance, Error : Process ID -2 is not a valid process ID. The actual issue occurred during an update to a table that has been used by Online application to update the action log, intially the DBAs have thought it is a blocking problem and trying to catch up the SPID to kill with no success. As th... (more)
category: Management | clicked: 1 | comment | | source: sqlserver-qa.net
tags: Best Practices, Connections, Distributed Transactions, DMC, Error Code, Kill, msdtc, Orphan, Rollback, spid
1
kudos
spam Kudos Remove

SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
published 1026 days, 4 hours, 41 minutes ago posted by pinaldavepinaldave 1026 days, 10 hours, 22 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Tuesday, July 28, 2009 6:24:13 AM GMT
SQL SERVER – List All Missing Identity Values of Table in Database « Journey to SQL Authority with Pinal Dave
The best part of any blog is when readers ask each other questions. Better still, is when a reader takes the time to provide a detailed response. A few days ago, one of my readers, Yasmin, asked a very interesting question: How we can find the list of tables whose identity was missed (not is sequential order) within the entire database? A big thank you to SQL Server Expert, Imran Mohammed, for his excellent response to this question. He also provided an extremely impressive script, which is well descr... (more)
category: Management | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQLAuthority, SQLServer
2
kudos
spam Kudos Remove

Shrink SQL Server 2008 Database Log File Script
published 1027 days, 4 hours, 32 minutes ago posted by sasa 1027 days, 15 hours, 17 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Monday, July 27, 2009 1:28:31 AM GMT
Shrink SQL Server 2008 Database Log File Script
Here is a quick script to shrink the database log file in a SQL Server 2008 database.  This procedure has changed, since the BACKUP command does not work the same way as previous versions.  Replace DatabaseName with the name of your database, and LogFileName with logical name of your log file... (more)
category: Management | clicked: 28 | comment | | source: extended64.com
tags: LogFile
1
kudos
spam Kudos Remove

When you should and shouldn't use PowerShell in SQL Server
published 1027 days, 4 hours, 32 minutes ago posted by sasa 1027 days, 23 hours, 36 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:10:20 PM GMT
When you should and shouldn't use PowerShell in SQL Server
PowerShell is cool, but it's not always appropriate. Here's a quick list to help you decide when to use it|Print|Add a comment| 106 Recommendations PowerShell is one of the coolest new things to come out of Microsoft in a long while, and it’s going to do more for server admin than anything else. That doesn’t mean, though, that it’s always the technology for every task. [ Cut straight to the key news for technology development and IT management with our once-a-day summary of the top tech news. Subscribe... (more)
category: Management | clicked: 4 | comment | | source: www.infoworld.com
tags: PowerShell
1
kudos
spam Kudos Remove

SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen
published 1027 days, 4 hours, 32 minutes ago posted by sasa 1027 days, 23 hours, 45 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:01:20 PM GMT
SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen
I had a great, unforgettable time at Teched India 2009 in Hyderabad. I had delivered a successful session on SQL Server Management Studio Best Practices, which created a lot of interest in community. I was truly amazed at the tremendous response I got. I received countless different questions on this subject as soon as the event was over. One of the most frequently asked questions was about my demo on how to increase real estate of SSMS (SQL Server Management Studio)... (more)
category: Management | clicked: 4 | comment | | source: blog.sqlauthority.com
tags: SSMS
1
kudos
spam Kudos Remove

Spooky: What do you connect to?
published 1027 days, 4 hours, 32 minutes ago posted by sasa 1027 days, 23 hours, 29 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:17:17 PM GMT
Spooky: What do you connect to?
I only recently discovered that SSMS will connect to different things. For instance, press the "New query" button. What were you connected to... (more)
category: Management | clicked: 2 | comment | | source: sqlblog.com
tags: SSMS
1
kudos
spam Kudos Remove

Defragmenting/Rebuilding Indexes in SQL Server 2005
published 1027 days, 4 hours, 32 minutes ago posted by sasa 1027 days, 23 hours, 30 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:16:03 PM GMT
Defragmenting/Rebuilding Indexes in SQL Server 2005
I have modified ispALTERINDEX, which is the stored procedure that I use to defragment/rebuild indexes in SQL Server 2005.  The changes include two bug fixes and one feature request... (more)
category: Management | clicked: 1 | comment | | source: weblogs.sqlteam.com
tags: Indexes
1
kudos
spam Kudos Remove

Apply Those Updates
published 1027 days, 4 hours, 32 minutes ago posted by sasa 1027 days, 15 hours, 23 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Monday, July 27, 2009 1:23:04 AM GMT
Apply Those Updates
Staying on top of patches for your applications can be important, especially when those patches can fix issues that are currently affecting your environment. I’ve run into this from time to time with where the fix for an issue is related to the current state of updates to the SQL Server instance... (more)
category: Management | clicked: 0 | comment | | source: stratesql.com
tags: SQL Server 2008, Updates
1
kudos
spam Kudos Remove

PowerShell's "Mini-Shell" Is Not A "Mini" Shell
published 1027 days, 4 hours, 32 minutes ago posted by sasa 1028 days, 10 hours, 57 minutes ago
Monday, July 27, 2009 12:13:38 PM GMT Sunday, July 26, 2009 5:48:49 AM GMT
PowerShell's "Mini-Shell" Is Not A "Mini" Shell
I just learned about a Connect item entered on Friday: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=475337. Here's the description in the item.Please invoke the full powershell not a "mini-shell". Powershell is very powerful but the mini-shell you get when invoking Powershell from the Management Studio is missing a lot of functionality. I'm not sure how the submitter determined that there was any missing functionality, because there isn't. SQLPS.exe is PowerShell 1.0... (more)
category: Management | clicked: 0 | comment | | source: sqlblog.com
tags: PowerShell, SSMS
1
kudos
spam Kudos Remove

Andy Leonard : More On Elegance in Database Design: Design Decisions
published 1028 days, 1 hour, 15 minutes ago posted by sasa 1028 days, 10 hours, 50 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 5:55:34 AM GMT
Andy Leonard : More On Elegance in Database Design: Design Decisions
Introduction I wrote recently on the importance of elegance in database design (Art vs. Science). In More on Elegance in Database Design: Complexity, I wrote about balancing the amount of complexity in design. In this installment, I want to talk about design decisions. Who's Buried in Grant's Tomb? How many states exist for two-state logic? It sounds like a trick question, or one of those interview questions that make you think a lot. I assure you this is neither. It's much worse; it's engineering. T... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: Elegant Design
1
kudos
spam Kudos Remove

Forced Parameterization: A Turbo Button?
published 1028 days, 1 hour, 15 minutes ago posted by sasa 1028 days, 10 hours, 35 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 6:11:27 AM GMT
Forced Parameterization: A Turbo Button?
Forced Parameterization: A Turbo Button? I never had the need to turn on the PARAMETERIZATION FORCED database option until this week.We pretty much use only stored procedures for our internal applications so the execution plans are almost always in cache and reused.This practice of using parameterized stored procedure calls, together with attention to detail in query and index tuning, allows us to comfortably handle several thousand requests per second on commodity hardware without taking special measur... (more)
category: Management | clicked: 0 | comment | | source: weblogs.sqlteam.com
tags: Performance
1
kudos
spam Kudos Remove

Data Vault Modeling Critics
published 1028 days, 1 hour, 15 minutes ago posted by sasa 1028 days, 10 hours, 29 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 6:16:35 AM GMT
Data Vault Modeling Critics
Our mentor Rushabh B. Mehta has pointed me to an interesting Web site http://www.danlinstedt.com/, where you can read about a modeling technique the author named Data Vault Modeling (DVM). I have not heard of this technique before. I read all of the five articled on the Data Vault technique, starting with http://www.tdan.com/view-articles/5054/ (you can find further links in the first article). I read slowly (not really thoroughly) articles 1, 2, 3, and 4, and briefly 5 (I am not interested in this c... (more)
category: Management | clicked: 1 | comment | | source: blogs.solidq.com
tags: Modeling
1
kudos
spam Kudos Remove

Bin packing part 4: The set-based disaster
published 1028 days, 1 hour, 15 minutes ago posted by sasa 1028 days, 10 hours, 22 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 6:24:04 AM GMT
Bin packing part 4: The set-based disaster
Almost a year ago now, I started a series of blog post on the bin packing problem. But after the first three posts, various reasons caused the research I still had to do for the fourth part to be massively delayed. It’s only now that I have finally found the time to finish my research and write up the fourth installment.   After a nine-month delay, I can hardly expect you to remember what I covered in the first posts, so you may want to follow these links to re-read that: ·        The first post inclu... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: Performance
Previous 1 2 3 4 5 6 7 Next