Viewing 15 posts - 8,746 through 8,760 (of 49,552 total)
The message is pretty clear. The login is the owner of one or more databases. You need to change the owner of those databases to be able to 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
June 12, 2014 at 7:03 am
Did you update all statistics with full scan after the upgrade?
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
June 12, 2014 at 6:40 am
IT researcher (6/12/2014)
The sql server starts everyday at 8:30 AM and stops around 9:30 PM.
Why?
SQL instances don't need to be rebooted daily. Hell, I know of instances 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
June 12, 2014 at 6:39 am
Grant Fritchey (6/12/2014)
For a change? Ha!
😀 :hehe:
Daily will get you going with meaningful data.
True, yes, it's a good starting point, better than the total wait stats since sometime...
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
June 12, 2014 at 6:21 am
John Mitchell-245523 (6/12/2014)
I don't know whether Inserted is available to the stored procedure
It's not. Only directly in the trigger.
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
June 12, 2014 at 6:19 am
IT researcher (6/12/2014)
SQL server restarts every night. Does these values reset on restart?
wait times are cumulative since SQL started
For a change I'm going to disagree with Grant. Daily 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
June 12, 2014 at 5:46 am
The only 'normal' which exists is normal for your server. Different databases, hardware and workloads will have different 'normal' wait times. It's also impossible to tell anything about yours, because...
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
June 12, 2014 at 5:15 am
It might be a recommendation for consistency, since functions do require the BEGIN ... END
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
June 12, 2014 at 5:12 am
Union all is usually the preferred way, if that's causing problems you could try inserting each resultset into a table variable and querying the table variable.
To say anything useful 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
June 12, 2014 at 5:10 am
Please enable the trigger and run a single-row insert into cat_transactions from Management Studio and post the exact, complete content of the messages pane afterwards.
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
June 12, 2014 at 4:24 am
crazy_new (6/12/2014)
GilaMonster,It says one row affected, so it does work right.
It shouldn't say one row affected. It should have more messages than that from the trigger's execution. That was 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
June 12, 2014 at 4:13 am
The only way that could happen is if there's a rollback occurring.
If you run an insert into cat_transaction from a management studio query window? What exactly do you see 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
June 12, 2014 at 3:41 am
From an application? When you connect to Management Studio? Something else?
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
June 12, 2014 at 3:32 am
http://www.sqlservercentral.com/articles/Indexing/68636/ (also see the other two in the series)
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
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
June 12, 2014 at 3:22 am
What data type is pd_desp?
To be honest, unless the description tends to be thousands of characters long or a LOB data type, it's probably fine as an include. You definitely...
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
June 12, 2014 at 3:10 am
Viewing 15 posts - 8,746 through 8,760 (of 49,552 total)