Viewing 15 posts - 61 through 75 (of 110 total)
Copy, then restore. Generally simplifies troubleshooting if the operation goes wrong. Some clients still have networks that just aren't man enough, not unknown for a tiny 20gb copy to fail...
August 23, 2017 at 8:25 am
July 19, 2017 at 7:26 am
July 19, 2017 at 3:50 am
There is NO reason for...
July 4, 2017 at 9:50 am
My longest-standing beef is with people (usually non-SQL DBA's/Developers) who think "SQL DBA" means "SQL" means I can code SQL. Usually the cheapskate end of everything, who thankfully I haven't...
June 30, 2017 at 2:57 am
June 20, 2017 at 2:46 am
John Mitchell-245523 - Monday, June 19, 2017 9:26 AMJoin sys.database_principals to sys.server_principals on sid=sid.John
Pretty close, this did it for me.......
June 19, 2017 at 10:14 am
Appreciate the help guys!!
Ok, I've put this together - bear in mind I'm NO Developer, this is the most SQL I've written in my DBA career, so...
June 2, 2017 at 4:22 am
Hi all - can anyone help with this?
May 30, 2017 at 2:30 am
The xp_readerrorlog proc takes up...
May 18, 2017 at 3:56 am
May 17, 2017 at 9:27 am
It was a good try, but no cigar ;(
I ran :
Select COUNT(*)
May 17, 2017 at 8:22 am
May 17, 2017 at 5:29 am
May 17, 2017 at 4:38 am
Viewing 15 posts - 61 through 75 (of 110 total)