Viewing 15 posts - 106 through 120 (of 1,048 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...
The probability of survival is inversely proportional to the angle of arrival.
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...
The probability of survival is inversely proportional to the angle of arrival.
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...
The probability of survival is inversely proportional to the angle of arrival.
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...
The probability of survival is inversely proportional to the angle of arrival.
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...
The probability of survival is inversely proportional to the angle of arrival.
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...
The probability of survival is inversely proportional to the angle of arrival.
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.
The probability of survival is inversely proportional to the angle of arrival.
May 21, 2013 at 8:16 am
Yes.
The probability of survival is inversely proportional to the angle of arrival.
May 15, 2013 at 1:42 pm
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.
The probability of survival is inversely proportional to the angle of arrival.
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...
The probability of survival is inversely proportional to the angle of arrival.
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...
The probability of survival is inversely proportional to the angle of arrival.
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...
The probability of survival is inversely proportional to the angle of arrival.
March 8, 2013 at 3:00 pm
No such feature exists. Wrap the two updates in a single transaction is what you want.
The probability of survival is inversely proportional to the angle of arrival.
March 8, 2013 at 8:00 am
Abu Dina (2/22/2013)
The probability of survival is inversely proportional to the angle of arrival.
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)) /...
The probability of survival is inversely proportional to the angle of arrival.
February 21, 2013 at 12:12 pm
Viewing 15 posts - 106 through 120 (of 1,048 total)