Viewing 15 posts - 12,166 through 12,180 (of 49,552 total)
What errors/messages suggest that you're running out of worker threads?
What version of SQL, what processor architecture, how many cores?
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
August 8, 2013 at 6:58 am
Can happen. Emergency mode is a last resort, it's not guaranteed to work in all cases.
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
August 8, 2013 at 6:54 am
Go and ask the person who told you this what a cookbook is and how to install is.
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
August 8, 2013 at 6:34 am
Sean Lange (8/7/2013)
GilaMonster (8/7/2013)
Sean Lange (8/7/2013)
GilaMonster (8/7/2013)
dbo is the schema name. Those two are identical, the .. is a shortcut for .dbo.
Gail doesn't this actually shortcut to the current user's...
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
August 7, 2013 at 12:51 pm
Sean Lange (8/7/2013)
GilaMonster (8/7/2013)
dbo is the schema name. Those two are identical, the .. is a shortcut for .dbo.
Gail doesn't this actually shortcut to the current user's default schema? 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
August 7, 2013 at 12:36 pm
Brandie Tarvin (8/7/2013)
GilaMonster (8/7/2013)
Jan Van der Eecken (8/7/2013)
GilaMonster (8/7/2013)
Jan Van der Eecken (8/7/2013)
BTW, is anyone going to SQLSaturday #243 in Cape Town? Gail is talking first thing in the morning.
I...
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
August 7, 2013 at 12:35 pm
Jan Van der Eecken (8/7/2013)
GilaMonster (8/7/2013)
Jan Van der Eecken (8/7/2013)
BTW, is anyone going to SQLSaturday #243 in Cape Town? Gail is talking first thing in the morning.I am? That's news.
That's...
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
August 7, 2013 at 11:08 am
dbo is the schema name. Those two are identical, the .. is a shortcut for .dbo.
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
August 7, 2013 at 11:07 am
Jan Van der Eecken (8/7/2013)
BTW, is anyone going to SQLSaturday #243 in Cape Town? Gail is talking first thing in the morning.
I am? That's news.
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
August 7, 2013 at 9:17 am
If SQL is using too much memory, reduce max server memory.
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
August 7, 2013 at 3:07 am
Why do you want to reduce memory usage? SQL uses memory to improve performance because memory is faster than disk. It will cache as much as it can to avoid...
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
August 7, 2013 at 2:09 am
andymay-496937 (8/6/2013)
Thanks for that, I'm not sure that Books on Line advice about putting the values in a table are that helpful for SSRS, but it's good stuff in general.
Well,...
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
August 7, 2013 at 1:39 am
From Books Online:
Including an extremely large number of values (many thousands) in an IN clause can consume resources and return errors 8623 or 8632. To work around this problem, store...
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
August 6, 2013 at 5:23 pm
Itzik Ben-Gan's T-SQL Fundamentals. Available from Amazon, there's a 2008 version and a 2012 version
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
August 6, 2013 at 5:09 pm
Chad Crawford (8/6/2013)
They did a movie too[/url] - wasn't too good, but I thought it was worth watching because I loved the series so much.
The movie's good if 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
August 6, 2013 at 1:54 pm
Viewing 15 posts - 12,166 through 12,180 (of 49,552 total)