Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.
2018-06-04 (first published: 2008-02-23)
47,274 reads
I think I am sorted with this now anyway.Advice is - Keep transaction very short - Return server to default isolation level READ COMMITTED when on and on error found. - Consider using HOLDLOCK
2005-04-07
well if the procs work.. nothing. SysDepends is used when ou ask sql server to show the object dependencies (spa needs table1,view2 and vice-verca)... but this is not always accurate. So I guess the worst that could happen is that you delete a proc that is actually needed but that sql server "said" it wasn't.
2005-02-21
I agree, you are better off explicitly typing the data rather than allowing SQL to decide as you can cuase yourself big issues especially if the rules change between SQL versions.
2004-10-22
Oops. I found the problem myself - persistence is the key. I omitted the "New" keyword when I declared the DataSet variable.
2004-06-11
2004-05-21
3 reads
As you may or may not read in another thread I created...I am having trouble implementing the drill down..I actually have it implemented and it works great in the ReportDesigner preview pane...but when I deploy to the ReportServer and page just reloads itself when I click on the (-) for drill into.Any ideas?
2004-05-20
First, that's NOT a large database. I've restored a 200+ GB database (yes, that's GIGABYTE).Next, how did you do the restore? Can you post your script?It looks like you may have used WITH NORECOVERY which will leave the database in LOADING state awaiting other backup files.WITH NORECOVERY is used when you have to also restore […]
2004-03-30
Hmmm... Well here is a quick sample SP I just wrote that should help you with the variable usage. USE pubs GO -- First check to see if the sproc exists and if so drop it. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('MySampleSproc')) DROP PROCEDURE MySampleSproc GO /*--------------------------------------------------------------------------------------- Name: MySampleSprocDescription: sample procedure for […]
2004-03-24
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-22
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers