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.
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
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
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
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
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.
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...
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.
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
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...
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...
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...
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...
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
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...
February 20, 2010 at 11:51 am
Viewing 15 posts - 33,856 through 33,870 (of 49,552 total)