Viewing 15 posts - 16,141 through 16,155 (of 19,564 total)
You can install it from your installation media. It is a part of the initial SQL Server setup. It must be selected in order to be installed.
March 21, 2010 at 3:24 pm
If you are certain that your volume of business has not changed in this database, check to see that nobody has copied a table into a "backup" table still in...
March 20, 2010 at 11:30 pm
Paul White NZ (3/20/2010)
March 20, 2010 at 4:00 pm
Paul White NZ (3/20/2010)
CirquedeSQLeil (3/20/2010)
Anti Nolock Association LeagueHighly amusing.
:hehe:
March 20, 2010 at 3:59 pm
Paul White NZ (3/20/2010)
...nolock is a free lunch.
Again, I blame the name.
All new DBAs 'know' that blocking and deadlocking are bad (:doze:). Blocks and deadlocks are caused by locks....
March 20, 2010 at 11:54 am
Is the mdf still large? By the end of your post it sounded like the backups had reduced back to normal.
Has somebody been reindexing?
Has somebody been creating copies...
March 20, 2010 at 10:01 am
petertrast (3/20/2010)
I gave it to her without the SQL code and she did a standard alphabet/number decode... I am going to try...
March 20, 2010 at 9:44 am
Tom.Thomson (2/8/2010)
GSquared (12/21/2009)
I had to decipher the code based on the usual methodology. I haven't seen the Frosty the Snowman movie since the 70s.
I did the same...
March 20, 2010 at 9:42 am
petertrast (3/20/2010)
March 20, 2010 at 9:36 am
What does the transaction log for the database look like?
How big?
What is the autogrowth on it?
How many vlfs are in it?
Compare the t-log for both tempdb and the user database...
March 20, 2010 at 9:28 am
Since you mention DMVs, you could start by looking for Glenn Berry's Dr. DMV Scripts.
You could also take a look at the book by Grant Fritchey on execution plans.
http://www.amazon.com/Server-Execution-Plans-Grant-Fritchey/dp/1906434026
March 20, 2010 at 12:22 am
vikrambansal1 (3/19/2010)
March 20, 2010 at 12:17 am
Paul White NZ (3/19/2010)
READ UNCOMMITTED gets a bad...
March 20, 2010 at 12:09 am
Paul White NZ (3/19/2010)
Kevin Bullen (3/18/2010)
I've run SET STATISTICS PROFILE ON, the execution plan is the same on both servers.
Seems to be, but I agree it would be interesting to...
March 20, 2010 at 12:07 am
Paul White NZ (3/19/2010)
CirquedeSQLeil (3/19/2010)
I'll award back points later for everyone on this one since it's not really a fair question, but thanks for all the comments.
That would be nice...
March 20, 2010 at 12:05 am
Viewing 15 posts - 16,141 through 16,155 (of 19,564 total)