Viewing 15 posts - 36,241 through 36,255 (of 49,552 total)
gardenlady (10/16/2009)
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
October 16, 2009 at 3:16 pm
GSquared (10/16/2009)
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
October 16, 2009 at 3:03 pm
I think it's sysadmin. I'd be very surprised if it's anything less since you can use it to read any page, anywhere in any database.
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
October 16, 2009 at 2:55 pm
Looks like MS Access. Specially with the comment 'under a single button click'
Likes without wildcards
Non-aggregate comparisons in the having clause
The same two predicates repeated several times with ORs between them....
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
October 16, 2009 at 2:52 pm
GSquared (10/16/2009)
Of course, if that particular page was affected by some transaction in the lost file....
As far as I'm aware, it doesn't matter. With a missing log file, the page...
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
October 16, 2009 at 2:41 pm
gardenlady (10/16/2009)
Here's some sample code. I'll look at the execution plan next. Thanks!
Forgive me for being blunt, but that's almost 600 lines of T-SQL. Perhaps you could narrow down where...
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
October 16, 2009 at 2:15 pm
talltop-969015 (10/16/2009)
GSquared (10/16/2009)
GilaMonster (10/16/2009)
GSquared (10/16/2009)
For hard-to-find, it can be a missing log backup (delete the file) that breaks the backup chain.
Want to be really nasty? After deleting said...
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
October 16, 2009 at 2:10 pm
Jeff Moden (10/16/2009)
Heh... wouldn't a reasonable alternative be to only have SQL Server on the SQL Server box? 😉
Unfortunately not. I've heard of a case where SQL was the only...
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
October 16, 2009 at 1:19 pm
Bob Hovious 24601 (10/16/2009)
Black Ice
Shadowrun?
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
October 16, 2009 at 12:53 pm
jcrawf02 (10/16/2009)
Steve Jones - Editor (10/16/2009)
whoop upside?what's next, shocking keyboards? loud raspberries when someone responds?
Seconded, all in favor?:-D
Aye.
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
October 16, 2009 at 12:51 pm
GSquared (10/16/2009)
For hard-to-find, it can be a missing log backup (delete the file) that breaks the backup chain.
Want to be really nasty? After deleting said backup, take 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
October 16, 2009 at 12:36 pm
Index types. Never yet found someone who could tell me two types and the differences between them
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
October 16, 2009 at 12:05 pm
ItalianOlgi (10/16/2009)
Or I shall ask the SQL Server expert from India I hired already for very little money?
If you hired him for very little money, you'll probably find he's the...
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
October 16, 2009 at 11:43 am
Not built in, but Kimberly Tripp wrote one.
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Updates-%28fixes%29-to-sp_helpindex2.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
October 16, 2009 at 10:41 am
Auto close is true by default on SQL express.
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
October 16, 2009 at 9:58 am
Viewing 15 posts - 36,241 through 36,255 (of 49,552 total)