Viewing 15 posts - 106 through 120 (of 1,047 total)
Excellent advice regarding the service master key... back it up even if you don;t think you'll need it... it may save you later on.
Saving scripts to recreate all of the...
May 30, 2013 at 1:13 pm
I highly recommend backing up your service master key and securing it in a safe place for all your critical servers. If you ever need to restore some production databases...
May 30, 2013 at 12:45 pm
Ed Wagner (5/30/2013)
The name of '##MS_DatabaseMasterKey##' or '##MS_ServiceMasterKey##' will tell you if it's a database master or service master key.
Symmetric Keys are stored in the same table and will...
May 30, 2013 at 12:35 pm
There will always be a service master key by virtue of install. You can back it up or restore it that's about it.
As far as database master keys, if you...
May 30, 2013 at 12:31 pm
Lynn Pettis (5/29/2013)
Can it skip the data transfer, the OP only wants the schema with no data.
Actually I have a standalone table scripting .net utility that will script out a...
May 29, 2013 at 11:13 am
I actually wrote my own CopySQLTable utility. It is a command line utility and works (syntax-wise) very much like the good ol' windows copy command. You can copy...
May 29, 2013 at 11:00 am
Sounds like you would be better off creating a custom .NET report page which uses the ReportViewer Control.
May 21, 2013 at 8:16 am
It would only rollback if there was an error in the SQL statement or the update process was terminated.
Doesn't appear to be the case here.
May 15, 2013 at 1:04 pm
There should be no need to do all that. More than likely the process is being blocked by some other process, have you checked for blocking? (sp_who2)
Having said that...
May 15, 2013 at 8:41 am
This is a case where CLR has marked improvements over the TSQL methodologies. I wrote a IPtoBigint conversion udf in C# and it was 10 times faster than the...
April 10, 2013 at 1:47 pm
The way you are using it, looking for that one character, it probably won't make a measurable difference.
Unless you need to know the index of the character/string I would use...
March 8, 2013 at 3:00 pm
No such feature exists. Wrap the two updates in a single transaction is what you want.
March 8, 2013 at 8:00 am
Abu Dina (2/22/2013)
February 22, 2013 at 6:53 am
I would leave the worker thread setting alone for now.
If both instances are the same, set max memory on each server = (TotalMemory - (OS & xtraSvcs memory)) /...
February 21, 2013 at 12:12 pm
Viewing 15 posts - 106 through 120 (of 1,047 total)