Viewing 15 posts - 6,751 through 6,765 (of 49,552 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,...
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
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...
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
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)
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
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...
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
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
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
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...
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
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...
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
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.
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
January 19, 2015 at 1:10 pm
Koen Verbeeck (1/19/2015)
GilaMonster (1/19/2015)
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
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...
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
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
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
January 19, 2015 at 8:28 am
Please don't start multiple threads for the same problem.
No further replies to this thread please.
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
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...
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
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...
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
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...
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
January 16, 2015 at 6:26 am
Viewing 15 posts - 6,751 through 6,765 (of 49,552 total)