Viewing 15 posts - 16,711 through 16,725 (of 39,970 total)
Good comments, and very true. NoSQL doesn't necessarily work for many of the highly transactional systems we have. However it might be nice for others. Maybe DSS, maybe some of...
March 14, 2011 at 9:29 am
I'll look one over as well, Craig
March 14, 2011 at 9:18 am
We have lots of scripts here that will do that. Look at some of these:
http://www.sqlservercentral.com/search/?q=backup+and+copy&t=s
March 13, 2011 at 9:17 am
First, don't shift to your domain account. That's a poor security practice, and depending on how your account is managed, it could be an issue.
Create a new domain account, with...
March 12, 2011 at 5:34 pm
Me too, now if they'd move a few more features, I'd be thrilled.
March 12, 2011 at 1:24 pm
What do the stats show you? Does it hang at the beginning? the end?
March 12, 2011 at 1:23 pm
Likely the statistics for the Content column indicates the is might be enough rows with a '', that it's worth just scanning the table. Even if you think it's quicker...
March 12, 2011 at 1:22 pm
It is scary, but requiring local access mitigates it a little. It's a back door that's designed this way, specifically for the people that forget SA or have a rouge...
March 12, 2011 at 1:20 pm
Glad it's working.
Data types are important in SQL Server, and you were relying on some implicit conversion to match a date to a character. That doesn't always work, and it...
March 11, 2011 at 6:01 pm
This is a merge issue, and I've had it happen with systems getting merged. Typically what you have to do is allow the new parent system to determine how data...
March 11, 2011 at 12:42 pm
DAC and command prompt are not the same. DAC can be used from Management Studio. If you have it open when you start up the instance, connect with "Admin:" and...
March 11, 2011 at 12:32 pm
Sorry, for the in place upgrade, things are fine.
For the side by side move to new hardware, sp_help_revlogin will let you script logins. Once you get the script and run...
March 11, 2011 at 12:05 pm
The roles will be moved over as is. There are issues moving security to a new server, but for an in-place upgrade your logins will remain and they will map...
March 11, 2011 at 10:51 am
Did you start the SQL Server in Single user mode, and are you connecting with the DAC connection?
March 11, 2011 at 10:34 am
I usually have called myself the data janitor. Makes people laugh and disarms them a bit from the last DBA being too self-important.
March 11, 2011 at 9:41 am
Viewing 15 posts - 16,711 through 16,725 (of 39,970 total)