Viewing 15 posts - 17,011 through 17,025 (of 49,552 total)
It will be spread across the files according to the proportional fill algorithm. Not the space free on the drive that affects that, the space free in the data 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
August 22, 2012 at 7:27 am
BrainDonor (8/22/2012)
GilaMonster (8/22/2012)
Nitpicking I can take, this is getting well beyond that.
I have to say Gail that it was a fascinating thread up to a point, and your examples 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
August 22, 2012 at 7:25 am
Maybe.
How much data it returns is not the question. The question is how much data does it have to read through to get those 30 rows. If it'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
August 22, 2012 at 7:17 am
Grant Fritchey (8/22/2012)
GilaMonster (8/22/2012)
Grrr. Why do some people want to nitpick holes in things I say and do it in a way that sounds very much like a personal attack?
Same...
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 22, 2012 at 3:15 am
SQL Kiwi (8/22/2012)
GilaMonster (8/22/2012)
No, I meant the one you're posting in. Order by in an insert.Oh right. I wonder what he'll come up with next on that one.
Possibly try...
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 22, 2012 at 3:11 am
SQL Kiwi (8/22/2012)
GilaMonster (8/22/2012)
Yes, same one, and it's the thread with Paul involved."But it's not the only target people could chase with the statement, would you agree?"
Only involved by blog...
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 22, 2012 at 2:51 am
Yes, same one, and it's the thread with Paul involved.
"But it's not the only target people could chase with the statement, would you agree?"
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 22, 2012 at 2:03 am
Many better options.
Read uncommitted is the same as nolock, allows for dirty reads, dupliate reads, missed reads. See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
What would probably be a better approach would be to consider...
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 22, 2012 at 1:37 am
jshahan (8/21/2012)
For example, would you have the procs set to recompile each time they are run? Would you make use of "OPTIMIZE FOR.." etc.
Not by default I wouldn't. I'd...
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 22, 2012 at 1:30 am
Grrr. Why do some people want to nitpick holes in things I say and do it in a way that sounds very much like a personal attack?
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 22, 2012 at 1:22 am
prettsons (8/21/2012)
As HowardW & GilaMonster already mentioned the causes of database suspect mode. Please check this article, it has full solution of the issue: http://data-base-recovery.blogspot.com/2012/03/how-to-repair-sql-server-2008-r2.html
Not to be nasty, but that...
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 22, 2012 at 1:19 am
No good reason to do that.
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 21, 2012 at 5:10 pm
If you don't wan the cached plan, then EXEC <procedure> WITH RECOMPILE and get one fresh for your execution that doesn't affect the plan in cache.
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 21, 2012 at 1:04 pm
Object_id is used to join to sys.objects (or sys.procedures if you prefer). Or you can use Object_name and pass it the object_id and database_id.
Note that sys.objects is database-specific and sys.dm_exec_procedure_stats...
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 21, 2012 at 12:33 pm
Both.
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 21, 2012 at 12:32 pm
Viewing 15 posts - 17,011 through 17,025 (of 49,552 total)