Viewing 15 posts - 9,376 through 9,390 (of 49,552 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...
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
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...
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
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...
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
April 9, 2014 at 2:15 am
WithDrawalDate >+ GETDATE()
meaning
WithDrawalDate > +GETDATE()
and since + is the default
WithDrawalDate > GETDATE()
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
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 +...
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
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...
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
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...
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
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...
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
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...
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
April 8, 2014 at 6:45 am
GilaMonster (4/7/2014)
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
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...
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
April 8, 2014 at 6:22 am
Try a DDL trigger on the DDL_SERVER_SECURITY_EVENTS event category.
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
April 8, 2014 at 6:19 am
ALTER INDEX ALL ON <Table Name> REBUILD
or
ALTER INDEX <index name> ON <Table Name> REBUILD
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
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.
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
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.
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
April 8, 2014 at 3:45 am
Viewing 15 posts - 9,376 through 9,390 (of 49,552 total)