Viewing 15 posts - 46 through 60 (of 147 total)
Ha ha you're right - and i have no issue with an underlying cursor for a one-off task like this, though i know there are some who disagree with me...
February 8, 2013 at 3:33 pm
No he did not find the solution. He found a workaround that prevents the error from occurring.
The fact is that a fatal error has occurred, and it should not...
February 8, 2013 at 12:09 pm
Often, you find yourself failing over several databases, or several hundred in a real disaster scenario.
This script checks all databases in one go, and avoids use of a cursor.
exec sp_msforeachdb...
February 8, 2013 at 11:52 am
You can get something close to what you want from the virtual file stats - if it's just relative IOPs and throughput for each database.
This script takes a sample over...
February 8, 2013 at 11:43 am
sp_changeobjectowner has been deprecated since 2000 in favour of ALTER SCHEMA and ALTER AUTHORIZATION.
From your question it looks like you want to change the schema from dbo to test, so...
February 8, 2013 at 6:18 am
That error number is fairly generic so we have to look at the message.
The fact that the message refers to TCP/IP and ConnectionWrite indicates network issues.
Combined with the fact that...
February 7, 2013 at 5:40 pm
Your addition to the script is returning the exact same data - ie. the last 240 minutes, it is just that you have modified it to display the wrong date...
February 7, 2013 at 11:21 am
Do you allow log backups to continue overnight, or is there a big gap since the last one when you run the 5am job? The full backup does not...
February 7, 2013 at 11:12 am
Are you running Enterprise Edition?
If so, you could specify ONLINE = ON.
February 7, 2013 at 11:03 am
I have used Redgate SQLMonitor, Quest Spotlight and Idera Diagnostic Manager at various sites and found them all to be competent - though the user interfaces could have been more...
February 6, 2013 at 4:42 am
There are 3 possible reasons I can think of for indexing a foreign key:
1. As has been said, to improve performance of deletes from the parent table
2. If you ever...
February 6, 2013 at 4:14 am
Try this
CREATE EVENT SESSION CSP_Procs
ON SERVER
ADD EVENT sqlserver.sp_statement_starting
(
ACTION(sqlserver.nt_username, sqlserver.username, sqlserver.client_hostname, sqlserver.sql_text, sqlserver.database_id)
WHERE sqlserver.like_i_sql_unicode_string(sqlserver.sql_text, '%val%')
)
February 5, 2013 at 9:07 am
Surely you must have at least one database that is not Simple recovery model?
So you need to schedule the log backup job as well. The schedule for this depends...
February 5, 2013 at 7:01 am
Add your servers to a group in Registered Servers.
Then in the morning, right-click on the group and select:
Or New Query...
February 5, 2013 at 4:35 am
Viewing 15 posts - 46 through 60 (of 147 total)