Reply to: Lynn Pettis

Well to respond, I am trying to do incremental backups to save on backup space but also have log shipping to a secondary site just incase the...

If you switched to high safety mode, does it still occur?

I know high speed mode is nice but there could be a network issue that is causing the disconnect.

Great Article, I didn't know about the traceflag for standard edition.

@SQLKnowItAll Thanks for the information, I have it setup using the SQL Service AD account... figured it would have the most access; alias it didn't have enough and the error...

Hey Bret,

In my experience with .Net CLR programming I have found using CLR SP/Functions to be very useful but with that being said I have also stuck to a...

I agree on readability, which is very important for maintaining code for developers.

One item I have found is that in certain situations referencing a CTE over and over again some...

Actually the CTE uses the table indexes quite nicely, just review the query plan and you will see it pulls the indexes from the table. (Most of the time) 😀

I...

I dunno about this answer, as http://www.microsoft.com/windowsserver2003/64bit/x64/datacenter.mspx has all of the points in your question and states 32 processors. Could the documentation be incorrect?

I don't like being wrong but...

I forgot to mention that the article is quite informative and I think with a little tuning I can run this with confidence.

The fixed code... I am not sure if it runs but I can create all the objects.

create table tblIndexUsageInfo

(

Sno int identity(1, 1)

,Dbname varchar(100)

,TableName varchar(100)

,IndexName varchar(300)

,Index_id int

,ConstraintType varchar(25)

,Type_desc varchar(100)

,IndexKeyColumn...

To break apart a concatenated string, please review http://beyondrelational.com/blogs/jacob/archive/2008/08/14/xquery-lab-19-how-to-parse-a-delimited-string.aspx; Jacob's articles have helped me out so much.

I've been using Solution 2, "FOR XML PATH" for a while now. I use substring to remove the first separator, I think I will look into using stuff.

I have...

Well I have learned something new today, I think I can go home now. 😀

Thanks for the information.

I get everything in your post... but what does the colon do?

-- Clear the temp table ...

ProcessNextServer:

DELETE #DRT_Update

Great post, I was wondering how to setup FILESTREAM without the need of Visual Studio.

One item I wasn't sure of was how is the file system security handled, since...