Viewing 15 posts - 1,291 through 1,305 (of 7,168 total)
mister.magoo (4/11/2013)
Thanks for that - will take a look.Much appreciated.
If you did happen to grab the download before I took it down, don't bother looking. I was misreading the BOM...
April 11, 2013 at 7:46 am
😛 I just realized something...converting a file from ANSI to UTF-8 is pretty much non-sensical unless you truly need the BOM. UTF-8 covers all 255 ANSI characters with the same...
April 11, 2013 at 7:43 am
You should be fine, i.e. after upgrading the Edition the build # should still be the same as what it was when you were on Standard, but check the build...
April 11, 2013 at 6:57 am
I am pretty sure I tried it before posting but that code has long since evaporated. I'll try it again though. Chances are I was using 2012 too so I'll...
April 11, 2013 at 6:50 am
When moving to the higher edition there is not too much to consider in the way of features since Enterprise has all features Standard does. The optimizer is a little...
April 11, 2013 at 6:42 am
The ? marks are a dead giveaway that non-printable ANSI characters are being pushed into an ANSI column or variable (i.e. VARCHAR or CHAR). The hollow squares might be a...
April 11, 2013 at 6:36 am
SQLTestUser (4/9/2013)
April 10, 2013 at 4:51 pm
This might help get you started:
$Instances = (Get-Content 'C:\Instances.txt') # Make a text file containing your instances, one on each line
[Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null
foreach ($instance in $Instances)
{
$sqlServer...
April 10, 2013 at 3:46 pm
Data Flow Task containing:
1. OLE DB Source that selects the data you need to export as a single resultset, i.e. a SELECT statement
2. Conditional Split that evaluates the ID column...
April 10, 2013 at 12:06 pm
ONLINE=ON is an Enterprise feature.
The rebuild operation, even with ONLINE=ON, can be blocked depending on the iso level and what is using that table...but 10 hours would be a seriously...
April 10, 2013 at 7:26 am
Envious...it must be quite a nice thing to have the opportunity to just walk up and ask one of our community's best questions like this once in a while :-)...
April 10, 2013 at 6:03 am
Tobar (4/10/2013)
Looking into to this more I do have a question:So to add a linked server you use sp_addlinkedserver and to delete it you use sp_dropserver?
Not a great naming convention...
April 10, 2013 at 5:54 am
Gosta Munktell (4/10/2013)
You don't tell us how big the file is.You might not be able to store it in the internal memory and read it reversed?
You do not need to...
April 10, 2013 at 5:25 am
Viewing 15 posts - 1,291 through 1,305 (of 7,168 total)