Viewing 15 posts - 33,961 through 33,975 (of 49,552 total)
Not really.
Google will find you cheap hotels, the rates keep changing so check closer to the time.
Do not underestimate the time required to get a Visa if you're 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
February 17, 2010 at 7:44 am
Roy Ernest (2/17/2010)
Does each User group get a free pass or something? I hope so... 🙂
Each PASS chapter gets, for the chapter leader. You have to be an affiliated PASS...
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 17, 2010 at 7:35 am
n.heyen (2/16/2010)
I tried to run dbcc shrinkdatabase (clarity,10) - this ran OK but didn't seem to release any space back to the OS.
Why do you want to shrink? Databases tend...
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 17, 2010 at 7:31 am
Dave Ballantyne (2/17/2010)
eshreya_support is overdoing it a bit , reported a few as spam
I'm cleaning up behind, reported one and noted the whoever gets the report to check everything 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 17, 2010 at 7:30 am
Run DBCC UPDATEUSAGE
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 17, 2010 at 7:28 am
Your index is less than 1 extent (8 pages) in size. There's no point in rebuilding that and, considering the way SQL allocates pages for very very small indexes, rebuilding...
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 17, 2010 at 7:02 am
http://en.wikipedia.org/wiki/Data_Definition_Language
http://en.wikipedia.org/wiki/Data_Manipulation_Language
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 17, 2010 at 6:38 am
If the database was in full recovery and you have all the log backups since that full backup and SQL is still running and still has the DB attached (even...
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 17, 2010 at 6:31 am
mitch.fh (2/17/2010)
I was wondering if this recommendation is true for the clustered index as many people say it "IS" the table.
The leaf level of the clustered index contains the actual...
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 17, 2010 at 6:28 am
If by interrupting the LSNs you mean truncating the transaction log, full backups never truncate the transaction 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 17, 2010 at 6:26 am
Make sure that the queries are written so that they can use indexes and do no unnecessary work. Make sure that the indexes support the queries.
Test question? Interview question?
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 17, 2010 at 6:24 am
Test question? Interview question?
Search in Books Online for 'Include columns' you should find several entries.
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 17, 2010 at 6:23 am
Test question? Interview question?
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 17, 2010 at 6:23 am
Test question? Interview question?
Try asking Google that question. You'll probably get lots of decent answers far faster than here.
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 17, 2010 at 6:22 am
Tim Januario-145496 (2/17/2010)
The difference between DDL and DML results in a Operand data type varchar is invalid for subtract operator exception.
RotFL. Lovely. 😀
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 17, 2010 at 6:21 am
Viewing 15 posts - 33,961 through 33,975 (of 49,552 total)