Viewing 15 posts - 5,701 through 5,715 (of 18,926 total)
Please provide sample data (insert statements) for all your problem cases and the required output for all of them.
May 26, 2011 at 11:41 am
Elliott Whitlow (5/26/2011)
Somehow I put Paul, Kalen, and such at well ABOVE Senior, level 4, 5, 10?CEWII
Agreed but if the "HR community" stops at level 3 then only the best...
May 26, 2011 at 11:37 am
Might be a good read for you too... todays featured article!
http://www.sql-server-performance.com/2011/index-maintenance-performance/
May 26, 2011 at 11:36 am
Does all that and way more...
May 26, 2011 at 11:32 am
msharma-393915 (5/26/2011)
220- We receieved the data
219 - Patient match found
218 - This is only...
May 26, 2011 at 11:31 am
Vicki Peters (5/26/2011)
If it's a UNION of several inserts, then wouldn't it all have to be inserted at once?
Union or union all? That could make a hell of a...
May 26, 2011 at 11:28 am
Soudns good... never been in a shop with 100s of servers, 1000s of dbs or 1+TB so level 2 sounds reasonable. I would never compare myself to a Paul...
May 26, 2011 at 11:23 am
Once the first insert is completed then that space can be reclaimed.
For the log it is also reclaimed if you run in simple. For bulk and full it takes...
May 26, 2011 at 11:11 am
If it gets stuck as you say make sure you're not waiting on db growth (could be tempdb too).
2M is not a big insert for sql server!
May 26, 2011 at 10:59 am
There's an import data gui in ssms.
May 26, 2011 at 10:56 am
Craig Farrell (5/26/2011)
May 26, 2011 at 10:53 am
You can use xp_cmdshell to get a list of files but that doesn't tell you from which db it comes from. You'd need to look it up the the...
May 26, 2011 at 10:34 am
Steve Jones - SSC Editor (5/26/2011)
I should have noted this is OS dependent. My apologies for that. From the explanation URL: NULL if the...
May 26, 2011 at 10:07 am
GilaMonster (5/26/2011)
Grab the plans from cache, straight as they are, insert into a table. Get that data to another server (dev/test/monitoring server), do the xml...
May 26, 2011 at 9:53 am
GilaMonster (5/26/2011)
That's only going to work for tables that don't have a clustered index. Table scans of a table with a clustered index show as clustered index scans
Do not...
May 26, 2011 at 9:45 am
Viewing 15 posts - 5,701 through 5,715 (of 18,926 total)