Viewing 15 posts - 23,626 through 23,640 (of 49,552 total)
No. This is not a bug, it's not a suggestion. Blog it if you want the world to know, Connect is for bugs and suggestions, not quirks of the T-SQL...
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
September 9, 2011 at 10:03 am
To be honest, no. I really, really, really don't ever recommend anyone use this, and posting it could give the impression that I do. Since this is a SAP system,...
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
September 9, 2011 at 10:03 am
There's a traceflag to turn parameter-sniffing off server-wide, but that will affect every single query and probably will be detrimental to most. I would not recommend using that, rather targetted...
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
September 9, 2011 at 9:56 am
No, because if you have multiple tables in a filegroup the data in the tables will be striped across all of them.
Objects are per-filegroup, not per-file.
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
September 9, 2011 at 9:55 am
Jack Corbett (9/9/2011)
So at least with 2005 SP4 the semi-colon doesn't exactly fix it, you need the EXEC or EXECUTE whenever including an SP call in a batch.
Yes you do....
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
September 9, 2011 at 9:52 am
Ninja's_RGR'us (9/9/2011)
MysteryJimbo (9/9/2011)
Ninja's_RGR'us (9/9/2011)
So once ";" are mandatory, the problem will go away.
I love this proposed new "feature". Millions of lines of code to be changed =...
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
September 9, 2011 at 9:50 am
MysteryJimbo (9/9/2011)
The first query appears to be starting a transaction named sp_who2.
The last one appears to have a problem...
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
September 9, 2011 at 9:48 am
General recommendation is to let the OS manage, but that's not necessary for SQL Server. SQL doesn't use the page file (well, if it does, you have problems already), so...
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
September 9, 2011 at 9:44 am
The Time data type is not a timespan. It's a point in time. So 04:30 is half past 4 in the morning, not a duration of 4 hours 30 min....
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
September 9, 2011 at 4:53 am
Would someone please explain to me the logic behind shrinking (making smaller) a full file?
If the file is full, it has not free space in it. Shrinking removes free space...
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
September 9, 2011 at 4:25 am
sqlfriends (9/8/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
September 9, 2011 at 2:30 am
Jeff Moden (9/9/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
September 9, 2011 at 2:26 am
sqldba_newbie (9/8/2011)
GilaMonster (7/17/2008)
It is possible to restore MSDB, but the process is not the same as for one of the user databases.
At the end of the article says...
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
September 8, 2011 at 3:54 pm
http://sqlserverperformance.wordpress.com/2007/12/17/windows-page-file-explained/
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
September 8, 2011 at 3:40 pm
codebyo (9/8/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
September 8, 2011 at 3:00 pm
Viewing 15 posts - 23,626 through 23,640 (of 49,552 total)