Viewing 15 posts - 13,831 through 13,845 (of 39,899 total)
I see the WMI query article and I'll get to it. Right now I have 16 in queue, up from 8 on Monday, and I went through 4 this week....
May 18, 2012 at 10:11 am
It's just a default setting. SQL Server puts the default port for the "default" instance at 1433. For any named instance, regardless of whether it's the first or second installation...
May 18, 2012 at 9:40 am
You can run BCP without a format file and it will help you create one, guessing at the columns.
May 18, 2012 at 9:36 am
SQL Kiwi (5/17/2012)
Steve Jones - SSC Editor (5/17/2012)
Smart-*** Kiwi.Paul Randal started it. :laugh:
Why am I not surprised.
May 17, 2012 at 5:01 pm
Brandie Tarvin (5/17/2012)
Hey, Steve, can you change the birth year in my profile to read 1776, please?😀
LOL, I always use Apr 1 for my birthday. Get lots of well wishes...
May 17, 2012 at 5:00 pm
Backup compression isn't available in every edition of SQL Server.
The CPU cost is the main thing, and it's not horrible, but it depends on when you do it and...
May 17, 2012 at 2:52 pm
SQL Kiwi (5/17/2012)
Steve Jones - SSC Editor (5/17/2012)
May 17, 2012 at 10:40 am
You shouldn't have to explicitly. It does have to be open, but if you just ran this, then the SMK should automatically open it.
If this is all your code,...
May 17, 2012 at 10:40 am
Short answer: my boss wanted the StackExchange style forums on the site
Long Answer: my boss made us implement the StackExchange style Q&A, which I think has merits. As Grant, Lynn,...
May 17, 2012 at 9:51 am
I use WordPress.com at http://www.voiceofthedba.com
1. Used the Titan theme from Theme Foundary. Didn't spend a lot of time looking around though. After seeing 5 or 10, my eyes start to...
May 17, 2012 at 9:46 am
The Master location is sent to SQL Server as a startup parameter for the service. In the Configuration manager (or services, don't use that), you can see the parameters. I...
May 17, 2012 at 9:43 am
Thanks to new data mining abilities I think I read that they have the ability, to 75% or 90% or something like that, to find an individual in the States...
May 17, 2012 at 9:41 am
so this is a string. You might look at the substring functions in SSIS and then derive the various parts based on finding the spaces, or dashe.
May 17, 2012 at 9:37 am
Lowell (5/15/2012)
MysteryJimbo (5/15/2012)
May 17, 2012 at 9:21 am
Agree with Rob, but are those separate cells or one cell?
May 17, 2012 at 9:17 am
Viewing 15 posts - 13,831 through 13,845 (of 39,899 total)