Viewing 15 posts - 28,366 through 28,380 (of 49,552 total)
I hope it's a really, really, really tiny database.
Why do you want to do something like this?
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
January 18, 2011 at 11:07 pm
Don't use 1204 on a SQL 2005 or 2008 server. It doesn't produce as much info as 1222 and it's harder to read, it's an older traceflag for SQL 2000.
You...
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
January 18, 2011 at 11:04 pm
mister.magoo (1/18/2011)
Just a thought - would I get any mileage from forcing a query plan - if that is possible when I can't get one that works!
Maybe, but it has...
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
January 18, 2011 at 10:54 pm
kthanigaivel (1/18/2011)
sorroy that table contains 50 thousand rows.
Still a pretty small table, especially if you mean 50 000 rows = 4.5MB. My answer stands as is.
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
January 18, 2011 at 10:50 pm
mister.magoo (1/18/2011)
Craig Farrell (1/18/2011)
I can't get to skydrive, cause it's...
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
January 18, 2011 at 3:51 pm
This may sound odd but...
What are the security settings on the linked server and what permissions do the linked accounts have on the remote server?
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
January 18, 2011 at 3:48 pm
jcrawf02 (1/18/2011)
you guys must wreak havoc on April Fools' Day (or its SA equivalent Gail, sorry)
It's called that here too. We (kinda) keep to the British tradition that the fool...
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
January 18, 2011 at 3:27 pm
Craig Farrell (1/18/2011)
GSquared (1/18/2011)
...because some poor fool will try to open your multi-terrabyte database file in MS Word...
*sprays coke on the screen* Thanks Gus, you just lightened up my...
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
January 18, 2011 at 2:52 pm
LutzM (1/18/2011)
GilaMonster (1/18/2011)
Steve Jones - SSC Editor (1/18/2011)
Well this is a depressing few pages in The Thread.I could make it worse, but I think maybe I'll decline to
Let me guess:...
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
January 18, 2011 at 12:03 pm
Del Lee (1/18/2011)
So, now I know you can restore a page. However, I don't see how this could be used practically with confidence.
Database corruption. Restore the entire...
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
January 18, 2011 at 12:01 pm
It's not an error, it's listed as a warning. If I'm not mistaken, that indicates that the disk partitions aren't aligned properly (google disk alignment). Again, not an error, not...
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
January 18, 2011 at 11:29 am
Steve Jones - SSC Editor (1/18/2011)
Well this is a depressing few pages in The Thread.
I could make it worse, but I think maybe I'll decline to
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
January 18, 2011 at 11:24 am
LutzM (1/18/2011)
Gail, is there any specific reason to use all columns in the index instead of moving some to the include section?
Yes. They're all in the where clause. Hence they're...
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
January 18, 2011 at 10:53 am
No further replies to this thread please.
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
January 18, 2011 at 10:22 am
sqldba_icon (1/18/2011)
I would like to know what are the general baselines for read/writes.
Fewer is better and if it changes without reason there's a problem
Lets say i am updating 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
January 18, 2011 at 10:21 am
Viewing 15 posts - 28,366 through 28,380 (of 49,552 total)