Viewing 15 posts - 10,846 through 10,860 (of 49,552 total)
The trial version of SQL Server is called Evaluation Edition, it has the features of Enterprise edition. You can download it from the Microsoft site.
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
November 24, 2013 at 6:02 am
Is the database going to grow again? If not, if you never expect it to get back to the 450GB, then do a once-off shrink. Be sure to leave enough...
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
November 23, 2013 at 1:34 pm
That should all be obtainable from sys.dm_db_partition_stats
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
November 23, 2013 at 8:07 am
Lowell (11/22/2013)
whether the command was run with ONLINE or not is not saved anywhere, I'm pretty sure.
It's not, because the option only affects the process of rebuilding and has no...
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
November 23, 2013 at 2:22 am
What database context are you running it in?
What database shows Active Transaction as the log_reuse_wait in sys.databases?
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
November 22, 2013 at 1:55 am
That's normal, every single session will have a shared lock on the database it uses and it will hold that lock until the session ends. This is to ensure that...
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
November 22, 2013 at 1:46 am
I suggest you go and make sure you know exactly what it is before you kill it, what it was running and from where. You shouldn't be guessing as 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
November 22, 2013 at 1:14 am
Opentran is database-specific, run it in the database that has the growing log. If your log reuse wait is active transaction, then you have an open transaction.
The number of sessions...
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
November 22, 2013 at 1:09 am
Something's leaving a transaction open. Identify who that is (from DBCC OpenTran and sys.dm_exec_sessions) and either commit the transaction or kill the session and let it rollback. Then do some...
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
November 22, 2013 at 12:41 am
SQLAli (11/21/2013)
Pietlinden,Yes, we shrunk the .mdf and alert moves to Warning from centreon. But i think it is not right resolution.
If you really do want to release space back 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
November 21, 2013 at 10:28 pm
Without seeing the procedure, no.
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
November 21, 2013 at 1:14 pm
rodjkidd (11/21/2013)
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
November 21, 2013 at 11:57 am
Stefan Krzywicki (11/21/2013)
I think you might be able to get some performance benefit if you choose your partition column very carefully.
Maybe. Depends on the query forms
If you find what...
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
November 21, 2013 at 8:46 am
Views can only be single SELECT statements. If you need looping or anything more than SELECT ... then consider a stored procedure.
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
November 21, 2013 at 7:22 am
I don't see an execution plan, I don't see complete index definitions and I only see part of the table definitions. Please read the article I referenced, trying to help...
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
November 21, 2013 at 7:19 am
Viewing 15 posts - 10,846 through 10,860 (of 49,552 total)