Viewing 15 posts - 27,901 through 27,915 (of 49,552 total)
r.vanlaake-1086273 (2/7/2011)
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
February 7, 2011 at 3:58 am
davidc-702140 (2/4/2011)
FROM sysobjects SO (NOLOCK)
INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID
AND SO.Type = 'P'
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
February 7, 2011 at 3:33 am
So you want every single procedure that does any form of manipulation on the columns before returning it to the client. So concatenating strings, portions of strings, any form 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
February 7, 2011 at 3:29 am
paul.knibbs (2/7/2011)
How on earth did she get away with that? If everyone she was working with KNEW she was useless, how had higher management not cottoned on to that fact?
Different...
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
February 7, 2011 at 2:05 am
paul.knibbs (2/7/2011)
I can't imagine someone who lied to get the job in the first place being willing to 'fess up when the excrement hits the rotating ventilation device...
Me neither.
I worked...
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
February 7, 2011 at 1:41 am
aslamnepanagar (2/7/2011)
Affected queried.Queries are large.
Some details of the queries
Using Temp objects,Table variables , cursors, 2-3 levels of nesting. Finally taking data from Jobs table.
I'd suggest optimising those. They don't sound...
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
February 7, 2011 at 1:31 am
Was the DB structured with just one filegroup or two?
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
February 7, 2011 at 1:17 am
That's not necessarily the best approach. Yes, it will stop parallelism, but it may be hiding a real problem (inefficient query and/or poor indexing) or it may cause a degradation...
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
February 7, 2011 at 1:16 am
Let the ranting begin... 😀
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
February 6, 2011 at 11:03 pm
The naming of the file is utterly irrelevant. You could call the data files .myDataFile and SQL wouldn't care.
If you want SQL to automatically spread the data among the files,...
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
February 6, 2011 at 10:52 pm
Have a look at the Geography data type and all the associated spatial functions
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
February 6, 2011 at 10:40 pm
2 weeks and 2 days to go. Sooo looking forward to first SQL Sat and to MVP summit.
Pity I have an imperial ton of things to be before then.
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
February 6, 2011 at 10:33 am
I just bought an iPad. Right now it's firmly in the category of toy. I do expect that is will become a useful tool, especially for writing.
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
February 6, 2011 at 9:48 am
How big is the table?
What's it's definition? (CREATE TABLE statement)
What are the queries that are affected?
Do you really need to rebuild the index? Does update statistics with full scan have...
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
February 6, 2011 at 9:37 am
If it's in the primary filegroup, SQL will automatically use it. It will spread data across all files in a filegroup.
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
February 6, 2011 at 5:33 am
Viewing 15 posts - 27,901 through 27,915 (of 49,552 total)