Viewing 15 posts - 40,951 through 40,965 (of 49,552 total)
Please read through this - Managing Transaction Logs[/url]
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 19, 2009 at 8:08 am
GSquared (2/19/2009)
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 19, 2009 at 8:07 am
Aaron N. Cutshall (2/19/2009)
I investigated the possibility of parameter sniffing, so I changed the function from an Inline Function to a multi-line function yet the problem persists.
How?
Can you,...
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 19, 2009 at 7:28 am
That sounds just like parameter sniffing. (http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/)
Post the code and exec plan?
Does it have to be a function?
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 19, 2009 at 6:32 am
For detach/attach, probably the same as SQL 2000, using the sp_detach_db and sp_attach_db procedures (see Books Online for details)
As for shrinking the log, why do you want to? Shrinking's a...
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 19, 2009 at 6:23 am
Duran (2/19/2009)
So the updgrade exam 2005 to 2008, 453, is out to do already, but there is no material to read from yet?
Please post unrelated questions in a new thread....
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 19, 2009 at 6:21 am
What number do you want back for the dates given?
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 19, 2009 at 6:20 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic660187-146-1.aspx
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 19, 2009 at 6:20 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic660190-338-1.aspx
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 19, 2009 at 6:19 am
swmsan (2/19/2009)
Many thanks for the advice. I am working more to improve my knowledge on SQL Server.
Then spend time here. On this forum you'll see hundreds of problems and questions,...
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 19, 2009 at 6:15 am
Grant Fritchey (2/19/2009)
It makes me wonder what people do all day at these jobs they've been slogging away at for years.
From prior experience working with people like that, as...
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 19, 2009 at 6:11 am
Roy Ernest (2/19/2009)
My problem is the management says I am too tough when giving interviews.
My former management used to tell me the same thing. So I expect that people know...
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 19, 2009 at 5:58 am
madhu.arda (2/19/2009)
1.I have to go database Mydb and execute drop statistics _WA_Sys_stdAQSKey_78415083 right?
Yup, for each of the statistics listed in the errors
2.how do we know these statistics are...
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 19, 2009 at 5:57 am
How many rows does the delete affect?
Why that choice of clustered index? It doesn't look like a very optimal one (wide, not unique, not ever-increasing).
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 19, 2009 at 5:54 am
elay (2/19/2009)
WE are to perform DBCC CHECKDB today. Hopefully it will work out.
CheckDB's not going to fix anything. It's a diagnostic that will show what's wrong.
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 19, 2009 at 5:53 am
Viewing 15 posts - 40,951 through 40,965 (of 49,552 total)