Viewing 15 posts - 541 through 555 (of 1,162 total)
What Lowell said, except a small point on the delete sample code. Whilst perfectly functional, you should get in the habit of using:
DELETE TOP(n)
rather than setting ROWCOUNT as it...
February 3, 2012 at 9:58 am
"Trans" is not a keyword.
The syntax is:
BEGIN { TRAN | TRANSACTION }
So, you can either use:
BEGIN TRAN
--or
BEGIN TRANSACTION
Since you have GO's in your script, the first batch (up to...
February 2, 2012 at 10:07 am
It won't help with blocking at all if they're accessing the same tables, in fact it would potentially make it worse.
It could help with physical resource contention if you're able...
February 2, 2012 at 7:10 am
Enterprise Edition has a feature called Resource Governor which allows you to restrict resources that I'm sure could group then into two different workloads, however it depends what you mean...
February 2, 2012 at 6:10 am
It's all possible, but performance would likely be pretty terrible running the host O/S, 4 VM's and 4 instances of SQL Server (including the production instance) all on the same...
February 2, 2012 at 5:27 am
Patience... You posted your question less than an hour ago.
You also haven't asked much of a question. Yes, it's possible to run SQL Server in a VM environment and yes...
February 2, 2012 at 4:48 am
sporoy (2/2/2012)
As you can see two execution plans are same, using same Index Seek, Key Lookup, Clustered Index Scan.
That's not what I see. One's using Nested Loops and the...
February 2, 2012 at 3:35 am
Not easily. You're basically stuck either using a 3rd party tool (like WinSCP etc.) and calling it from the command line in an Execute Process Task, a 3rd party SSIS...
February 2, 2012 at 2:15 am
GSquared (2/1/2012)
Steve Jones - SSC Editor (2/1/2012)
GSquared (2/1/2012)
HowardW (2/1/2012)
Not sure whether to call it spam or not, but most of his...
February 2, 2012 at 1:59 am
Steve Jones - SSC Editor (2/1/2012)
GSquared (2/1/2012)
HowardW (2/1/2012)
Not sure whether to call it spam or not, but most of his posts...
February 1, 2012 at 9:17 am
Is this guy annoying the hell out of anyone else?
Not sure whether to call it spam or not, but most of his posts wouldn't pass the Turing Test.
February 1, 2012 at 8:30 am
I have a similar setup and it all works ok for me. Are both accounts local admins? I could imagine the lower privilage stuff Windows 7 does wouldn't work so...
January 31, 2012 at 8:57 am
Setting aside why you'd need a 16 digit number (that's an awfully large number), the literal way of doing what you're asking is a combination of IDENTITY and a check...
January 30, 2012 at 6:02 am
There's a good blog post here from the SSIS team:
http://blogs.msdn.com/b/mattm/archive/2009/11/13/handling-slowly-changing-dimensions-in-ssis.aspx
In my experience, the built in SCD transform is too slow to be usable in most situations I've dealt with, I...
January 27, 2012 at 10:27 am
Sean Lange (1/25/2012)
January 27, 2012 at 6:37 am
Viewing 15 posts - 541 through 555 (of 1,162 total)