Viewing 15 posts - 211 through 225 (of 245 total)
Use Select * from sys.databases
Find the dbid
Select * from sys.sysprocesses where dbid = dbid
Find the spid number
kill spid number
If the spid is a minus number you have an...
December 13, 2013 at 5:18 am
Excellent. Nice one. Never used Sysmembers. Every day is a school day.
December 4, 2013 at 3:02 am
I need to know who is in the DBO role for each database on my server.
Via a script.
December 3, 2013 at 10:10 am
Thanks,
Errors beyond severity (X),
Disk Space.
Blocks
Growth Trends
Failed Access.
Performance Thresholds.
Failed Jobs.
Changes made by Sysadmins.
General DBA STUFF.
November 28, 2013 at 8:59 am
I don't believe there is a problem this is the normal behaviour of SQL.
November 7, 2013 at 5:01 am
If you are in fact rebuilding indexes, this will update the statistics automatically. Forcing sprocs that to recompile on the first time thety are executed. Hence it takes longer the...
November 6, 2013 at 2:25 am
It will be creating an execution plan during the first execution.
November 5, 2013 at 8:43 am
Thanks, wasn't a tricky one just needed confirmation.
November 1, 2013 at 3:02 am
Simple as setting back to 0 to turn off with no damage done if there are any performance issues.
October 31, 2013 at 10:33 am
Thanks I read through a post by Dave Pinal, nowhere have I read about a con for turning this on, only pros.
If there is no negative why is this...
October 31, 2013 at 10:19 am
Did you reindex the db and update stats before going live?
October 9, 2013 at 3:13 am
Does the account that is making the connection have access to the dbs on the remote server?
October 3, 2013 at 3:56 am
Thanks all cracked it.
Started from scratch.
1 Backed UP db.
2 Set off T-log backups
3 Captured 3/4 Tlogs.
4 Ran my script.
5 Created another Backup.
6 Ran my script again.
7 added missing TRNs to...
September 25, 2013 at 9:05 am
No it has always been in Full recovery mode.
I'll try it again. As long as I know it should work then I'll bang on with it.
September 25, 2013 at 8:03 am
Grant Fritchey (9/25/2013)
September 25, 2013 at 7:42 am
Viewing 15 posts - 211 through 225 (of 245 total)