Viewing 15 posts - 33,856 through 33,870 (of 49,552 total)
They're stored just like any other value.
You can use DBCC PAGE to view data/index pages if you like. It's undocumented, but there are enough articles mentioning 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
February 22, 2010 at 11:43 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/FindPost870654.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 22, 2010 at 1:08 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/FindPost870654.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 22, 2010 at 1:08 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/FindPost870654.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 22, 2010 at 1:08 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replied to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/FindPost870654.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 22, 2010 at 1:07 pm
Jack Corbett (2/21/2010)
Following MVP's on twitter last week during the MVP Summit made me wish I was there.
Me too.
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 21, 2010 at 11:24 pm
Braindumps are cheating. They are actual questions taken from the exam in violation of the NDA that all exam candidates have to accept.
Using or supplying braindumps can result in your...
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 21, 2010 at 11:22 pm
CirquedeSQLeil (2/21/2010)
Enjoy your break.
No break (except from the forums). On-site with client this week.
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 21, 2010 at 1:26 pm
Can ask someone(s) to keep an eye on the corruption forum for the week please? I'm pretty much offline for the week. Thanks
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 21, 2010 at 1:14 pm
Chris Kitchen (2/20/2010)
1. Would you recommend looking into anything else to try and pin point where the table scans and deadlocks are coming from?
Yes. Look at the exec...
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 20, 2010 at 11:46 pm
eddy-644184 (2/20/2010)
But i try to minimize the use of select *, so its kinda a habit for just typing what...
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 20, 2010 at 1:14 pm
eddy-644184 (2/20/2010)
I will on the other hand always make sure that for the IF EXISTS i always select 1 field only and mostly this would be the primary key (indexed)
EXISTS...
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 20, 2010 at 12:37 pm
Hunterwood (2/16/2010)
It´s allways a good rule of thumb to use TOP 1 together with EXISTS, because it prevents the database engine from doing unneccesary work.
Got an example that proves that?
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
February 20, 2010 at 12:32 pm
ChrisM@home (2/20/2010)
Can you please confirm which version of SQL Server you are using?
Chris Kitchen (2/20/2010)
I'm running SQL Server 2000 Enterprise Edition on Win2k3 Enterprise Edition
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 20, 2010 at 12:13 pm
subbarayudu.net 37258 (2/20/2010)
Which events I selected while running the trace file for Stored procedure.
For what with stored procedures? Execution? Execution plan? compiles? changes? something else?
What permissions i need to run...
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 20, 2010 at 11:51 am
Viewing 15 posts - 33,856 through 33,870 (of 49,552 total)