Viewing 15 posts - 6,751 through 6,765 (of 49,571 total)
timotech (1/20/2015)
Please how do i recover from this error while trying to attach my database:
Could not open new database 'MediaMonitoring'. Create database is aborted
msg 9003, level 20, state 1,...
January 20, 2015 at 5:25 am
free_mascot (1/20/2015)
If your database is not production than you can attached mdf file without any ldf file and it will automatically take care of creating new ldf file.
No, it...
January 20, 2015 at 5:24 am
What is the exact version of the server? Both principal and mirror (SELECT @@Version)?
What is the version of SSMS you're using (Help -> About)
January 20, 2015 at 5:22 am
sashby78 (1/19/2015)
My questions are these:- Do query plans using an index that have its stats updated get trashed when the stats are updated?
Yes
Why in a query that uses a date/time and...
January 19, 2015 at 11:52 pm
There aren't any SQL 2014 exams. They updated the MCSE-level 2012 ones.
https://borntolearn.mslearn.net/b/weblog/archive/2014/03/10/certification-update-sql-server-2014
January 19, 2015 at 11:47 pm
The previous developer probably made a mistake and left out the USE statement when he deployed once. User tables should not be created in master in general, definitely not tables...
January 19, 2015 at 11:44 pm
robin.pryor (1/16/2015)
I'm in the middle of correcting the problem, but error log files are generating at a staggering pace. Is there a way to stop logging?
Depends what's getting logged.
Is 'audit...
January 19, 2015 at 1:12 pm
sqlGDBA (1/16/2015)
Set the database recovery model to simple. It should at least reduce the logging.
Transaction log != Error log.
January 19, 2015 at 1:10 pm
Koen Verbeeck (1/19/2015)
GilaMonster (1/19/2015)
January 19, 2015 at 11:42 am
Well this is fun.
Officially, according to the government, South Africa uses the , as the decimal point. In reality, everyone, including the government, uses the .
Windows 7, when used with...
January 19, 2015 at 9:29 am
This would probably be a good place to start http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2
January 19, 2015 at 8:28 am
Please don't start multiple threads for the same problem.
No further replies to this thread please.
January 19, 2015 at 7:34 am
sp_reset_connection is used with connection pooling, it's called when a connection is reset and goes back into the connection pool.
As for analysing your trace, have a look at the methodology...
January 19, 2015 at 5:08 am
That's related to parallel table/index scans. Probably means you have a lot of inefficient queries which are doing large scans. Worth looking into
btw, aggregated wait stats over 5 days is...
January 19, 2015 at 3:22 am
To be honest, I'd call MS customer support. Scheduler deadlocks and related problems are fairly hard to debug and may involve reading stack dumps, they have the tools for this...
January 16, 2015 at 6:26 am
Viewing 15 posts - 6,751 through 6,765 (of 49,571 total)