Viewing 15 posts - 28,921 through 28,935 (of 49,552 total)
RowNumber with both partition by and order by will give you the position of each of the rows you want within the groupings, then you can filter on that. Rank()...
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
December 11, 2010 at 11:36 am
ChrisM@home (12/11/2010)
GilaMonster (12/11/2010)
ChrisM@home (12/11/2010)
What's surprising me, today, is the number of folks lurking in here - you're not all avoiding the Christmas crowds now are you?
Spent the morning doing 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
December 11, 2010 at 11:25 am
Could you perhaps be a little more specific as to what warning you got and when you got it?
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
December 11, 2010 at 10:39 am
ChrisM@home (12/11/2010)
What's surprising me, today, is the number of folks lurking in here - you're not all avoiding the Christmas crowds now are you?
Spent the morning doing a SAN perf...
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
December 11, 2010 at 10:38 am
Yes.
I just did a detach from SQL 2000 attach on SQL 2008 R2 this morning, and the processor architecture makes no difference to the file structure. x86, x64 and IA...
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
December 11, 2010 at 7:30 am
It's only possible if you have a backup from before the query you executed by mistake.
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
December 11, 2010 at 6:58 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/Topic1033289-391-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
December 11, 2010 at 5:54 am
george sibbald (12/10/2010)
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
December 10, 2010 at 10:43 pm
Just in case, run the following and check that it doesn't return anything.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
December 10, 2010 at 3:02 pm
Just on the IN and the Join
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
As for the rest, look at the exec plan and see what's happening.
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
December 10, 2010 at 1:01 pm
The number given as m_objId should match to a table in sysobjects. The index id of 255 means this is a LOB page.
Sure you're in the right database? Easy...
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
December 10, 2010 at 12:58 pm
If what you're trying to do is clean up too many VLFs, then you do (once and only once) want to shrink to 0 and then grow to the appropriate...
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
December 10, 2010 at 12:55 pm
Glen Potter (12/10/2010)
TIt was just a surprise that MS would create a view or any other object that was not more precisely named e.g., "sys_routes", or "net_routes".
sys.objects
sys.indexes
sys.partitions
It's a 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
December 10, 2010 at 12:50 pm
pjdiller (12/10/2010)
SanDroid (12/10/2010)
pjdiller (12/10/2010)
Yes? I didn't say it'll throw an error, just that it's ignored. It's the same as running
DBCC SHRINKFILE (N'my DB logfile' , 0)
Ultimately, my question is whether...
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
December 10, 2010 at 12:45 pm
SanDroid (12/10/2010)
What happens when you hide an application feature that a Novice was using somewhere that requires him to make a $250.00 M$ support...
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
December 10, 2010 at 9:10 am
Viewing 15 posts - 28,921 through 28,935 (of 49,552 total)