Viewing 15 posts - 736 through 750 (of 1,157 total)
I found it to be much more accurate than functions like Soundex
November 23, 2011 at 6:17 am
I should probably mention its an enterprise/development only component of SSIS
November 23, 2011 at 5:59 am
I've done a fuzzy lookup clean up of addresses before using SSIS. The datasource would be your raw data with a fuzzy match on you clean datasource.
Do a...
November 23, 2011 at 5:56 am
SQL Server only from the Idera offering and that was around £3000 a licence.
With Spotlight, from what I remember, to monitor anything useful other than sql you needed to buy...
November 23, 2011 at 4:11 am
Also, I was never responsible for monitoring anything other than SQL servers so the ability to check for the existence of another server was usless to me
November 23, 2011 at 3:07 am
I went the opposite way when I did my product assestment.
I found Spotlight is pretty (impressive for management) but too full of fluff and not intuitive to use....
November 23, 2011 at 3:05 am
The only things you need to do in conjunction with standard DR preparation (DB Backups, login scripting etc) is script all publications and subscriptions.
If all you have is a corrupt...
November 22, 2011 at 6:48 am
You may also find this is a bug in the scripter and sp_helptext will help you.
November 22, 2011 at 6:42 am
Stewart "Arturius" Campbell (11/22/2011)
yes, you can.However, bear in mind that, whenever replication re-snapshot takes place, all manually added indexes will disappear.
You can add a post snapshot script to re-add the...
November 22, 2011 at 5:58 am
L' Eomot Inversé (11/20/2011)
November 21, 2011 at 2:22 am
Koen Verbeeck (11/20/2011)
Sean Lange (11/18/2011)
Koen Verbeeck (11/18/2011)
That will only work if she keeps the lit on the pot, so that pressure rises within the pot.
I don't think you can increase...
November 21, 2011 at 2:19 am
Dev (11/14/2011)
MysteryJimbo (11/13/2011)
This is ripped out of one my installation...
November 16, 2011 at 6:40 am
Steve Jones - SSC Editor (11/14/2011)
MysteryJimbo (11/11/2011)
I...Circumstances caused me to leave college and do manual work
Warehouse line worker
Forklift driver
Did those help you study/work harder?
Id like to think so. I...
November 14, 2011 at 12:45 pm
Same applies.
MysteryJimbo (11/13/2011)
Low Rider (11/11/2011)
1)Will each of the sql instance have a different IP ?
Yes. Each instance will have its own resource group and it will require its own...
November 13, 2011 at 8:02 am
There really isnt a lot to automate. You can do this either in batch file or in powershell.
This is ripped out of one my installation batch files.
C:\admin\SQL Silent Install\SQL2005\SQLServer2005SP3-KB955706-x64-ENU.exe"...
November 13, 2011 at 4:27 am
Viewing 15 posts - 736 through 750 (of 1,157 total)