… if there is too much information everywhere, how do we know what to get, how to filter it and what to make out of it? . . . → Read More: Where do you get your SQL Server knowledge?
|
|||||
|
It happens often. Too often, maybe. A DBA goes to a company, looks at the system, which is running slow and and the business people are losing faith in, and the DBA creates an index or two and the system starts performing 50 times better. And then everyone seems to be quite happy. If you are a . . . → Read More: Thank you for the index, DBA! (you saved my system!) The following 3 scripts will give you information about your database tables… . . . → Read More: How to find information about your database tables Here is the question: how can you determine how many and what cross-database queries are running on your server? . . . → Read More: Question of the week: how do you find cross-database queries? So, if you have a stored procedure, containing several IF statements, does the cached plan get recompiled every time the procedure is executed? . . . → Read More: Plan re-compilations with multiple IF statements in a stored procedure?  |
 |
||||
|
Copyright © 2010 Feodor Georgiev's blog - All Rights Reserved |
|||||
|
|
|||||
