Viewing 15 posts - 10,696 through 10,710 (of 49,552 total)
Not the solution, but the reason.
When rebuilding an index, the old index is only dropped once the new one is complete. It's for ease of rollback (can just drop 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
December 8, 2013 at 11:39 pm
tmlink99 (12/8/2013)
3. Editor then says "Oh, well, we can't publish this after all. Sorry."4. Editor then plagiarizes article under his own name, getting credit and maybe paid.
Stock standard copyright...
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
December 8, 2013 at 10:21 pm
Yup, or set up an extended events session to run permanently. Dunno if the latter would meet your requirements though.
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
December 8, 2013 at 1:32 pm
Unless you have some custom logging implemented, you can't get that info. SQL doesn't track 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
December 8, 2013 at 10:16 am
You're going to have to give us a lot more info than that to help you debug.
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
December 8, 2013 at 5:40 am
A backup is the size of the data in the file + the amount of log space needed to restore consistently. It is not the sum of the sizes of...
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
December 8, 2013 at 1:58 am
As with most things, heavy is relative to your app, not an overall distinction.
Look in Books Online for the definitions of the fields, google for any articles or blog posts...
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
December 8, 2013 at 1:34 am
You want me to go to google, search for statistics, then link some of the articles that google finds?
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
December 8, 2013 at 1:33 am
Kill the query so that the user gets annoyed and re-runs it?
If you're running out of space for TempDB you need to either change the queries so that they...
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
December 7, 2013 at 2:38 pm
naga.rohitkumar (12/7/2013)
Client want to get the data full [full from sunday] upto tuesday 1.30 pm how will you restore the database.
Can't be done. If the client wants point in...
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
December 7, 2013 at 1:10 pm
A restore has to create an entire database, hence mdf and ldf. The log file is not an optional part of the database.
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
December 7, 2013 at 1:08 pm
There are tonnes of blog posts and articles on statistics available. Spend some time with your favourite search engine and you'll find lots.
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
December 7, 2013 at 1:02 pm
That's not contention, that's just queries using a lot of TempDB.
Query the sys.dm_db_session_space_usage to identify sessions using lots of TempDB. You can join it back to sys.dm_exec_sessions to get 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
December 7, 2013 at 1:01 pm
Define 'TempDB issue'? Why do you think it's TempDB contention?
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
December 7, 2013 at 1:45 am
A restore recreates the database exactly as it was when it was backed up. The only thing that puts a checksum on a page is when that page is read...
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
December 7, 2013 at 1:39 am
Viewing 15 posts - 10,696 through 10,710 (of 49,552 total)