Viewing 15 posts - 106 through 120 (of 813 total)
Luis Cazares (2/17/2014)
February 17, 2014 at 8:35 am
Getting family members off of XP will be difficult. Also difficult is getting businesses off of XP.
For the former, I tend to recommend Linux, if nothing else for the...
February 17, 2014 at 8:14 am
Production and test VM's use VMWare ESXi hypervisor (legally free for use as long as you don't do certain things, one example being rent out entire guests) on a whitebox;...
February 14, 2014 at 2:06 pm
A few thousand rows? Just use the INSERT statements.
A hundred thousand rows? BCP or BULK INSERT - that many INSERT statements at once often hit memory issues (even...
February 13, 2014 at 9:08 am
Welsh Corgi (2/12/2014)
Nadrek (2/12/2014)
Welsh Corgi (2/12/2014)
IMHO, there is nothing wrong with using or at least being familiar with the Import/Export Wizard.
Upgrading hundreds of import/export packages to a new version of...
February 12, 2014 at 12:03 pm
Welsh Corgi (2/12/2014)
IMHO, there is nothing wrong with using or at least being familiar with the Import/Export Wizard.
Upgrading hundreds of import/export packages to a new version of SQL Server?
February 12, 2014 at 11:01 am
SQLRNNR (2/11/2014)
Ed Wagner (2/11/2014)
As an example, what if I were to look...
February 12, 2014 at 9:56 am
Very strange, if the next DIFFs worked fine without a FULL in between the failure and the success.
The closest I've seen to this is
"Error 952: Database is in 'transition' state"
when...
February 12, 2014 at 9:50 am
Bah; no need for a wizard for a few hundred rows on a one-off import when a simple EXCEL formula creates your INSERT statements for you.
=CONCATENATE("INSERT INTO #YourTable VALUES ('",A1,"')")
Grab...
February 12, 2014 at 9:37 am
Bottom line: If you actually want security, you need to store the encryption keys on something you own, not something the client owns. Expect to spend a lot of...
February 12, 2014 at 9:34 am
The first key to performance tuning: Don't panic.
The second key, as mentioned in the article, is to have enough knowledge to be able to do very fast root cause determination...
February 11, 2014 at 10:27 am
GilaMonster (1/14/2014)
Moving TempDB is easy. The other three, not so much.
MSDB and Model are fairly easy, too.
Master's where you have to pull out the fun startup parameters.
February 10, 2014 at 12:04 pm
Please don't conflate changing employers with changing jobs, roles, responsibilities, or tasks.
I spent awhile working at a large company where it was quite normal for people who do...
February 10, 2014 at 11:22 am
EDIT: As the OP didn't mention any dependency, I agree with the other posters - create two jobs if the steps are independent of each other.
One option (if and only...
February 7, 2014 at 11:29 am
I consider the ideal to be a broad general base with one or more deeper specializations; akin to an ocean floor with some (Marianas) trenches.
Some problems need that deep, specialized...
February 7, 2014 at 11:26 am
Viewing 15 posts - 106 through 120 (of 813 total)