Viewing 15 posts - 5,011 through 5,025 (of 49,571 total)
Check the value of log_reuse_wait_desc. It tells you why VLFs couldn't be marked reusable last time SQL tried. There are many reasons why the log might not be cleared in...
August 14, 2015 at 4:16 pm
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
Eirikur Eiriksson (8/14/2015)
Chris.Hubbard4U (8/14/2015)
I have a database In Recovery.Where do I check the completion status of the recovery?
Quick thought, query sys.dm_exec_requests and check for command='RECOVERY'
😎
I queried that...
August 14, 2015 at 4:13 pm
SQLisAwE5OmE (8/14/2015)
If both logins/users exist on both PRD/DR, then you just need to do the orphan user fix.
Yes, but unless he fixes the root problem (the mismatched SIDs), he'll have...
August 14, 2015 at 10:14 am
Probably both.
If the data changes once a month and is queried often, then you can add a job after it's loaded to pre-aggregate into tables for later querying, then tune...
August 14, 2015 at 8:08 am
Not 'an' insert operation. Inserts multiple, probably lots of them. You can use server-side trace to watch what the apps are doing (your only option on SQL 2005), just watch...
August 14, 2015 at 4:58 am
Could be a shrink operation ran, could be inserts caused page splits. If it's the former, stop shrinking. If it's the latter, try dropping the fill factor of the index...
August 14, 2015 at 4:46 am
The error is "Access is denied". The SQL Server service account does not have rights to read the file in the new location. You need to give it full control...
August 14, 2015 at 4:44 am
Eric M Russell (8/13/2015)
Also it supports statistics and non-clustered indexes...
Table variables can have nonclustered indexes. No stats, but they can have nonclustered indexes. You just have to define them in...
August 13, 2015 at 2:20 pm
SQLRNNR (8/13/2015)
GilaMonster (8/13/2015)
Views upon views upon #$%$%^%$#$ views! The same damn table is getting queried 8 times.
I am dealing with that with a few clients.
Then they sit there and wonder...
August 13, 2015 at 10:29 am
Ed Wagner (8/13/2015)
August 13, 2015 at 9:56 am
Views upon views upon #$%$%^%$#$ views! The same damn table is getting queried 8 times.
August 13, 2015 at 9:52 am
Brandie Tarvin (8/13/2015)
GilaMonster (8/13/2015)
Sean Lange (8/13/2015)
Every table name and every column name are exactly 6 UPPER case letters.
I'm working with one of those. Fortunately it's not case sensitive, but...
August 13, 2015 at 8:32 am
Sean Lange (8/13/2015)
Every table name and every column name are exactly 6 UPPER case letters.
I'm working with one of those. Fortunately it's not case sensitive, but the tables are...
August 13, 2015 at 8:16 am
Unnecessary. When you run the ALTER DATABASE to take it offline, specify ROLLBACK IMMMEDIATE, that'll disconnect everyone
August 13, 2015 at 7:09 am
Viewing 15 posts - 5,011 through 5,025 (of 49,571 total)