Viewing 15 posts - 9,376 through 9,390 (of 49,571 total)
You won't be able to drop it.
You can try a restart of SQL. It's not a general solution for rollbacks, only for the specific case of what looks like a...
April 9, 2014 at 3:30 am
charipg (4/9/2014)
A previous restore operation was interrupted and did not complete processing on file 'abc_data'. Either restore the backup set that was interrupted or restart the restore sequence.
i.e. Restore the...
April 9, 2014 at 3:01 am
smallmoney (4/8/2014)
My guess is the credit card authorization guy would go first.
I would hope not. I would hope that the first person who was ready goes first. Otherwise, you...
April 9, 2014 at 2:15 am
WithDrawalDate >+ GETDATE()
meaning
WithDrawalDate > +GETDATE()
and since + is the default
WithDrawalDate > GETDATE()
April 8, 2014 at 8:45 am
Nothing. It's not an operator. However + designates a positive numeric value (like - designates a negative number), it's optional, but it's allowed and spaces are permitted between the +...
April 8, 2014 at 8:41 am
yuvipoy (4/8/2014)
Here comes another question, if the recommended index relationship in DTA shows this informations, should not we run the statistics?
You're mixing up statistics and indexes. They are two very...
April 8, 2014 at 8:11 am
rollercoaster43 (4/8/2014)
2 Previous versions of SQL Server cannot read compressed backups.
This one isn't really a restriction. You can never restore down-version anyway, no matter whether the backup is compressed or...
April 8, 2014 at 7:21 am
Someone ran the Database Tuning Advisor against your database and probably accepted all recommendations without doing the testing which they should have done.
But, that's not a statistics object (what I...
April 8, 2014 at 7:18 am
Automatic create stats will only create single column stats. There are cases (rare ones) where you may want multi-column stats. Or you may want to turn off auto create and...
April 8, 2014 at 6:45 am
GilaMonster (4/7/2014)
April 8, 2014 at 6:23 am
What the hell gives you the idea that there's a memory leak?
Let's see...
Lempster (3/6/2014)
http://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/
GilaMonster (3/11/2014)
Chapter 4: http://www.red-gate.com/community/books/accidental-dba
Go and do some reading on how SQL uses its memory and how to...
April 8, 2014 at 6:22 am
Try a DDL trigger on the DDL_SERVER_SECURITY_EVENTS event category.
April 8, 2014 at 6:19 am
ALTER INDEX ALL ON <Table Name> REBUILD
or
ALTER INDEX <index name> ON <Table Name> REBUILD
April 8, 2014 at 4:38 am
I will repeat myself...
That is a .net error. SQL Server is not written in .net, hence it's not a SQL Server error.
April 8, 2014 at 3:46 am
sashif0 (4/8/2014)
Verify the processor affinity and IO affinity being used.
They should be at the defaults. They're also unrelated to memory usage.
April 8, 2014 at 3:45 am
Viewing 15 posts - 9,376 through 9,390 (of 49,571 total)