tag:blogger.com,1999:blog-2453693540149032389.comments2023-05-18T14:11:09.911+01:00sql solacer5d4http://www.blogger.com/profile/09999231147372917249noreply@blogger.comBlogger53125tag:blogger.com,1999:blog-2453693540149032389.post-77711180543342283032017-05-16T21:07:06.877+01:002017-05-16T21:07:06.877+01:00thank you, good spot.thank you, good spot.r5d4https://www.blogger.com/profile/09999231147372917249noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-16848628514012821932017-05-16T19:13:44.994+01:002017-05-16T19:13:44.994+01:00Missing a '?' in there. Like USE ? Otherwi...Missing a '?' in there. Like USE ? Otherwise it won't look anywhere but at the current db.DonOmitehttps://www.blogger.com/profile/10625819322102913461noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-55171835322185540022016-04-15T06:30:44.715+01:002016-04-15T06:30:44.715+01:00Nice Article !
Really this will help to people of...Nice Article !<br /><br />Really this will help to people of SQL Server Community. <br />I have also prepared small note on this, What happend when row overflow and data exceeding 8KB size in SQL Server.<br /><br />http://www.dbrnd.com/2016/04/sql-server-what-happened-when-row-overflow-and-data-exceeding-8kb/Anonymoushttps://www.blogger.com/profile/01365030762397385247noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-21233055690407385892015-02-02T09:00:11.435+00:002015-02-02T09:00:11.435+00:00Thank you very much for pointing me to that James,...Thank you very much for pointing me to that James, will have to give it a go.<br />You can teach an old dog new tricks it would appear :)<br /><br />Admittedly the single user mode & restart is old news but I found myself doing it again so I figured I'd put some notes up.r5d4https://www.blogger.com/profile/14304363884917352516noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-17544361164075312142015-02-01T17:41:27.272+00:002015-02-01T17:41:27.272+00:00You can actually fix this without any downtime in ...You can actually fix this without any downtime in most or many cases. See this for example: http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/Anonymoushttps://www.blogger.com/profile/16354333489135538141noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-87911237157740500762014-02-25T20:21:36.107+00:002014-02-25T20:21:36.107+00:00A quicker way is... This will only give you the s...A quicker way is... This will only give you the script for those databases that have AutoShrink on.<br /><br />select 'alter database ['+name+'] set Auto_Shrink OFF' from master.sys.databases where database_id > 4 and is_auto_shrink_on = 1<br /><br />Anonymoushttps://www.blogger.com/profile/06473640789111228414noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-29454683329026419372013-11-27T15:37:47.304+00:002013-11-27T15:37:47.304+00:00Nice!
Tnx for sharing,
LeeNice!<br /><br />Tnx for sharing,<br />LeeLeehttps://www.blogger.com/profile/01629368198763986112noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-16306292465712087812013-07-03T07:22:05.647+01:002013-07-03T07:22:05.647+01:00Nice post very helpful
dbakingsNice post very helpful<br /><br /><a href="http://www.dbakings.com/sqldatabase/SQLIndexes.aspx" rel="nofollow">dbakings</a>Anonymoushttps://www.blogger.com/profile/14178155909391788234noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-33639495517552344492013-05-22T08:02:59.562+01:002013-05-22T08:02:59.562+01:00Thanks.It's really helped me.Thanks.It's really helped me. Sampath Lokugehttps://www.blogger.com/profile/13193493511446234762noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-2544741004206585662013-04-24T10:06:27.822+01:002013-04-24T10:06:27.822+01:00Awesome! Worked for me in SQL2008 R2 Express :)Awesome! Worked for me in SQL2008 R2 Express :)Graham Downshttps://www.blogger.com/profile/05058937158808902451noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-89797594731487400392012-08-14T16:23:51.284+01:002012-08-14T16:23:51.284+01:00Thanks! It saved my timeThanks! It saved my timeDmitry Pavlovhttps://www.blogger.com/profile/08089953123394668584noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-63073534236145305032012-07-15T22:16:23.666+01:002012-07-15T22:16:23.666+01:00Yes, I concur. We just recreated a server from ba...Yes, I concur. We just recreated a server from backups and I was having issues updating jobs. It's good to know the solution is a simple one. :)alissa914https://www.blogger.com/profile/07754244792815442921noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-62551391222167732622012-07-06T23:14:18.618+01:002012-07-06T23:14:18.618+01:00need to fix it for case sensitive databases:
Here...need to fix it for case sensitive databases:<br /><br />Here you go:<br /><br />-- Tasks waiting.<br /><br />SELECT * FROM sys.dm_os_waiting_tasks <br />GO<br /><br /><br />--Tasks being blocked.<br />SELECT * FROM sys.dm_os_waiting_tasks WHERE blocking_session_id IS NOT NULL <br />GO<br /><br />--Details of blocking issues.<br />SELECT PROCESS_BLOCKING.spid 'Holding ID', <br /> RTRIM(PROCESS_BLOCKING.status) 'Status', <br /> 'Lock Type' = CASE syslockinfo.rsc_type <br /> WHEN 1 THEN NULL <br /> WHEN 2 THEN 'DATABASE' <br /> WHEN 3 THEN 'FILE' <br /> WHEN 4 THEN 'INDEX' <br /> WHEN 5 THEN 'TABLE' <br /> WHEN 6 THEN 'PAGE' <br /> WHEN 7 THEN 'KEY' <br /> WHEN 8 THEN 'EXTENT' <br /> WHEN 9 THEN 'RID' <br /> WHEN 10 THEN 'APPLICATION' <br /> ELSE NULL <br /> END, <br /> SUSER_SNAME(PROCESS_BLOCKING.sid) 'Holding User', <br /> SUSER_SNAME(PROCESS_WAITING.sid) 'Waiting User', <br /> PROCESS_WAITING.spid 'Waiting ID', <br /> 'Database' = CASE <br /> WHEN syslockinfo.rsc_dbid = 0 THEN '[NULL]' <br /> ELSE DB_NAME(syslockinfo.rsc_dbid) <br /> END, <br /> syslockinfo.rsc_objid 'Object ID', <br /> RTRIM(PROCESS_BLOCKING.hostname) 'Holding Host', <br /> RTRIM(PROCESS_WAITING.hostname) 'Waiting Host', <br /> RTRIM(PROCESS_BLOCKING.program_name) 'Holding Program', <br /> RTRIM(PROCESS_WAITING.program_name) 'Waiting Program', <br /> PROCESS_BLOCKING.cmd 'Holding Command', <br /> PROCESS_WAITING.cmd 'Waiting Command', <br /> PROCESS_BLOCKING.cpu 'CPU Time', <br /> PROCESS_BLOCKING.physical_io 'I/O', <br /> PROCESS_BLOCKING.memusage 'Mem Usage' <br /> FROM master.dbo.syslockinfo <br /> JOIN master.dbo.sysprocesses PROCESS_BLOCKING <br /> ON syslockinfo.req_spid = PROCESS_BLOCKING.spid <br /> JOIN master.dbo.sysprocesses PROCESS_WAITING <br /> ON syslockinfo.req_spid = PROCESS_WAITING.blocked <br /> AND PROCESS_BLOCKING.spid = PROCESS_WAITING.blocked <br /> WHERE PROCESS_BLOCKING.spid <> @@SPID <br /> GORCShttps://www.blogger.com/profile/10072565796201540320noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-40440935188230544132012-06-13T13:45:36.320+01:002012-06-13T13:45:36.320+01:00I woulod have said yes.
If anyone knows different,...I woulod have said yes.<br />If anyone knows different, feel free to post.r5d4https://www.blogger.com/profile/09999231147372917249noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-66367920673174259852012-06-13T13:40:29.105+01:002012-06-13T13:40:29.105+01:00Good info, but I have a question: I create columns...Good info, but I have a question: I create columns in the dataset (through derived columns task), do I also need to account for them when performing these calculations?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-1452274112019140792012-05-17T20:14:38.802+01:002012-05-17T20:14:38.802+01:00Just wanted to drop a thank you note!!
Ran into an...Just wanted to drop a thank you note!!<br />Ran into an issue on a log shipping database where the MSDB database had grown to 16Gb in size. After using your "Clear Backup History " to do some pruning on the main culprit of sysjobhistory, I put your "history cleanup" job in place to keep the MSDB tidy.<br /><br />Cheers.AMBhattihttps://www.blogger.com/profile/16327500134757802079noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-90790259995454713822012-04-21T16:17:36.855+01:002012-04-21T16:17:36.855+01:00THANKS VERY MUCH!!!!!! HELPED ME A LOT IN MY ASSIG...THANKS VERY MUCH!!!!!! HELPED ME A LOT IN MY ASSIGNMENT!Oshini Perera || Oceangirl || Princess Miahttps://www.blogger.com/profile/02324486242922077557noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-5824932276826030382012-04-18T19:52:44.837+01:002012-04-18T19:52:44.837+01:00Thank you!! it really works!!!!!Thank you!! it really works!!!!!claudiohttps://www.blogger.com/profile/08293720581708014491noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-52830540941092618742012-04-05T14:14:31.477+01:002012-04-05T14:14:31.477+01:00good info...good info...Anonymoushttps://www.blogger.com/profile/13802535971432896916noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-4067329945781408382012-03-25T13:18:06.466+01:002012-03-25T13:18:06.466+01:00Thns, I almost forgot about it. Worked on 2008 R2Thns, I almost forgot about it. Worked on 2008 R2Saurabh Jaiswalhttps://www.blogger.com/profile/06183643979044599363noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-54467001405591439582012-03-25T13:17:15.777+01:002012-03-25T13:17:15.777+01:00Thnx, I almost forgot about this. Worked on 2008 R...Thnx, I almost forgot about this. Worked on 2008 R2Saurabh Jaiswalhttps://www.blogger.com/profile/06183643979044599363noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-14992371012454158352012-02-06T17:49:48.460+00:002012-02-06T17:49:48.460+00:00make sure you apply the suggestions above to this ...make sure you apply the suggestions above to this tag:<br />.msrs-site_title<br />in order for the SSRS 2008 site title to change!<br />Regards,<br /><br />Ralph Schwehr, DBARalph Schwehrhttps://www.blogger.com/profile/03284095792689502075noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-3436015175737991792012-01-27T10:50:18.961+00:002012-01-27T10:50:18.961+00:00Thank you Siva, have updated the post. :)Thank you Siva, have updated the post. :)r5d4https://www.blogger.com/profile/09999231147372917249noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-35409840334482863172012-01-27T07:26:18.188+00:002012-01-27T07:26:18.188+00:00Good one and the Topic covers is informative.
dat...Good one and the Topic covers is informative. <br />data in Bytes = 44740776 / 1024 = 45814554624 B<br /><br />small correction in above formula, its not division its multiplication.Siva Kumarhttps://www.blogger.com/profile/15417462748225908801noreply@blogger.comtag:blogger.com,1999:blog-2453693540149032389.post-82089427360507867752011-12-01T15:52:59.590+00:002011-12-01T15:52:59.590+00:00Just a note from your other post that we saw 101 b...Just a note from your other post that we saw 101 being important if you are dealing with US instead of 103 for the UK.<br />http://sqlsolace.blogspot.com/2011/09/are-my-databases-being-used.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SqlSolace+%28sql+solace%29jason7655https://www.blogger.com/profile/01635647038190609886noreply@blogger.com