Viewing 15 posts - 33,526 through 33,540 (of 49,552 total)
Gianluca Sartori (3/12/2010)
That would be funny! I was officially nominated DBA two weeks ago, it's a bit early to enter a competition and pretend that I'm "exceptional"! 😛
Considering some of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2010 at 7:36 am
and how fast time flies.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2010 at 2:51 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2010 at 2:21 am
One point for each post, points for correctly answering QotD according the the number granted by the question.
If you look at the http://www.sqlservercentral.com/TotalScores page, Lynn has 11813 points total, 9960...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2010 at 2:16 am
I don't have time to redesign the table and rewrite for you.
Once you have the domain in a separate column, then you can use straight forward IN to do direct...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2010 at 2:14 am
The problem is the leading wildcards in the where clause. Those are not SARGable and hence a table scan is required.
Consider redesigning the table so that the domain of the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2010 at 12:40 am
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2010 at 12:36 am
SELECT <column list> FROM (
SELECT <column list>, ROW_NUMBER() OVER (Partition By Category Order By (SELECT NEWID())) AS RowNo
FROM Table1) sub
WHERE rowNo <=3
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 3:01 pm
When a backup is restored the DB is recreated in exactly the same state it was at the time it was backed up. If there are no triggers in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 2:54 pm
Bit conditions should be stored in bit columns. One field for each condition. Two reasons.
Storing multiple values in a single field is a violation of First Normal Form. All columns...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 2:52 pm
Luke L (3/11/2010)
I wonder how long it be 'til he catches Steve?
Interesting.
Difference in post count between Steve and Jeff and between Jeff and I is almost identical. I suspect...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 12:22 pm
Grant the lock pages permission. Leaving that unset is asking the OS to swap SQL's memory out for no good reason.
Were the disk counters spiking to 'unacceptable' values or was...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 12:17 pm
Have a look in the SQL error log. If login failures are logged, which I believe is the default, the failure will be listed there with a state that;s not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 12:13 pm
GTR (3/11/2010)
Is this in production? Did you try to bring database online with alter command?
Since the question is almost a year and a half old, I'm guessing it's not longer...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 12:09 pm
It won't be several unless you're dealing with many millions of pages in the index. The upper levels of indexes are very small in relation to the leaf level and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 12:08 pm
Viewing 15 posts - 33,526 through 33,540 (of 49,552 total)