Viewing 15 posts - 27,646 through 27,660 (of 49,552 total)
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1066937-1550-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
February 21, 2011 at 12:34 am
What's an MCQ?
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, 2011 at 12:34 am
There is no such thing as an unlogged operation. Every data modification will log.
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, 2011 at 12:29 am
Haven't looked beyond some of the obvious new features. I intend to take a closer look when the next CTP is released.
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, 2011 at 4:23 pm
WayneS (2/20/2011)
For those going to SQL Saturday #69 in Philly, I'll be presenting @ 2:15. I'm getting pretty excited about this!
At the time you present I'll be on a plane...
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, 2011 at 4:19 pm
sqlchanakya (2/18/2011)
Say my tale has the following structure:
( RID varchar(20) - 20bytes
TAID Bigint - 8 bytes
...
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 19, 2011 at 12:00 pm
sqlchanakya (2/19/2011)
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 19, 2011 at 11:24 am
I don't understand what you're asking. What 'issue'?
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 19, 2011 at 7:14 am
When you took the backup, you striped it across two files, not one. If the backup was taken from management studio and there were two files listed in the backup...
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 19, 2011 at 4:11 am
sqlchanakya (2/18/2011)
If this is the case, how a unique non-clustered index would be beneficial over a non-unique non-clusterd index.
It generally isn't.
The cluster should be unique, because of the need for...
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 19, 2011 at 2:53 am
sql_butterfly (2/19/2011)
Apart from that if any suggestions are still welcome (like using some locking hints or forcing Row ocks etc).
Don't use hints unless you are absolutely certain 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
February 19, 2011 at 2:44 am
If you have never taken a backup, the logs would have been truncating automatically. You'd know if they hadn't, the logs would be many times the size of the data...
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 18, 2011 at 2:49 pm
Stefan Krzywicki (2/18/2011)
GilaMonster (2/18/2011)
jcrawf02 (2/18/2011)
Will somebody just punt the damn ball and call the half? jeez.... :-D:-P
Half of what?
If you want to stop cricket play, you call lunch, drinks break...
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 18, 2011 at 2:16 pm
jcrawf02 (2/18/2011)
Will somebody just punt the damn ball and call the half? jeez.... :-D:-P
Half of what?
If you want to stop cricket play, you call lunch, drinks break or bad light.
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 18, 2011 at 2:08 pm
Stefan Krzywicki (2/18/2011)
Oops! Run an odd number of creases? Make an odd number of runs? Terminology difficulty! : -)
Make an odd number of runs. The crease is the white line...
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 18, 2011 at 2:07 pm
Viewing 15 posts - 27,646 through 27,660 (of 49,552 total)