We are trying to exceed HIPPA requirements and a paranoid Compliance area. So we most probably will come closer to DOD standards in the near future. Although I did forward...

SET ODD_BUT_TRUE_MODE ON

About 9 months ago the CEO of our healthcare system had a new hard disk (larger capacity) installed in his desktop computer. Due to the sensitive nature of...

I'm not an advocate of the almost forgotten GOTO, but I have seen it in of all places, vendor supplied SPs. Mind you, these are not Mom'n'Pop vendors either. Some...

Thanks to one and all for providing an interesting discussion. I'll throw my support to Andy on 1, 2 and 3. Time and experience have shown that they work in...

please do not cross post --> http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=336187

SET UNCOMMON_SENSE_MODE ON

Stupid is as stupid does.

SET UNCOMMON_SENSE_MODE OFF

Here's a great site for Data Warehousing: http://www.tdan.com/

How big is the database ? Double check your maintenance plan (teh Integrity tab). You probably do not want to run a DBCC CHECKDB every time before you backup a...

Please do not cross post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=334856

What was the process doing (Inserst, Updates, Deletes) ? Did any of the target tables have trigger(s) on them ? Were the table(s) being manipulated very large ? Have you...

I've never transferred  a table quite that large - 85 Gb. My largest to date was about 10 Gb. I whole heartedly advise some testing, especially since text column(s) are...

hmmm ... its been around for a little over 6 months ... curious that there are no links to vendor whitepapers yet unless I am not looking in the right...

Options ... hmmm ... I would start with your direct IT superior. If you cannot arrive at a workable solution to improve things I'd check with  Human Resources next. There...

I have been lucky in my career. Only two employers, about 3 years in all out of 24+, did I opt to 'move' from. My criteria for the 'ideal/perfect' company is simple:

I...

SET UNCOMMON_SENSE_MODE ON

Jerks and their situations are like the weather. There is only one thing that you can change - your own perception of them or the situation.

If that...