Viewing 15 posts - 17,161 through 17,175 (of 22,214 total)
SQL Agent can be used to create the schedule. As posted above, you just need to run a script to start a trace. I recommend output to a file.
June 18, 2009 at 7:07 am
You can join anything on anything through a TSQL statement. No requirements at all. You might get some... interesting... results, but there are no strict requirements.
However, if you're talking about...
June 18, 2009 at 7:00 am
I wouldn't even call it apples & grapefruit. I'd say it's apples & chairs that you're comparing. Good luck sitting on the former or eating the latter. MVP can be...
June 18, 2009 at 6:58 am
Scotch... and beer. Or beer... and scotch.
Single malt (Highland or Orkney) followed by a good ESB... ah, makes life worth living.
June 18, 2009 at 6:43 am
I just tried QA against 2008. It works. Nominally. I haven't run a full-on regression test or anything.
I'm sorry too. I thought you, the OP, were trying to find ways...
June 18, 2009 at 6:34 am
OK? What's the problem and/or question?
You've got a cursor. It looks like it's doing updates.
It's hard to comment in any other way without knowing what you're trying to do...
June 18, 2009 at 6:06 am
"free admission to the contest"
I'm pretty sure the contest is free.
No, I don't need to see the "best minds" speak. I sat through a session with someone that I really...
June 18, 2009 at 6:02 am
First, don't run the profiler gui on your production systems. Instead use profiler to create a server-side trace (do a search on that phrase, it'll tell you everything you need...
June 18, 2009 at 5:47 am
jason (6/17/2009)
thanks , i will give it a try...By the way,
How to optimize tempdb if i want to use Snapshot Isolation
There are several white papers on optimizing tempdb available...
June 18, 2009 at 5:38 am
I don't understand what ISQLW does that SQLCMD does not?
From the sounds of it, you really might benefit from Powershell.
June 18, 2009 at 5:31 am
Gail is 100% correct.
You could look into using snapshot isolation as a way to reduce locking issues. It increases the load on tempdb and some on the CPU, but...
June 17, 2009 at 9:30 am
Import/Export uses SSIS. You can go to SSIS directly. It's more work, but you can make a more efficient DTL.
June 17, 2009 at 9:24 am
In a perfect world, no. In reality, yeah. But specifically what would be the difference? I'm not sure. I haven't found the export wizard to create the most efficient ETL...
June 17, 2009 at 8:38 am
There is a template, but, like Gus says, unless they do precisely the same thing every time to create a new proc and no one ever just starts typing (same...
June 17, 2009 at 8:10 am
Assuming the source tables are not being updated, no, it should only be putting shared locks on them for reading. It might cause excessive I/O, memory, or CPU use while...
June 17, 2009 at 7:56 am
Viewing 15 posts - 17,161 through 17,175 (of 22,214 total)