Viewing 15 posts - 11,641 through 11,655 (of 22,214 total)
And for those interested, you can run an upgrade directly from CTP3.
November 19, 2011 at 5:58 am
So you have a WHERE clause against a 30,000 row multi-statement table valued function... To quote a famous man "Well there's your problem.[/url]"
Seriously though, you may have any number...
November 18, 2011 at 4:02 pm
WayneS (11/18/2011)
Congrats Grant for making the Top 10 Community Choice Bloggers list! Keep up the good work!
Thanks.
I had no idea I was doing good work.
November 18, 2011 at 2:11 pm
WayneS (11/18/2011)
:w00t::w00t::w00t:Just passed 70-451. Now I have all exam pre-req's for 88-970 done... just not sure I'm ready for that one yet though.
Well done.
November 18, 2011 at 11:54 am
Ninja's_RGR'us (11/18/2011)
Steve Jones - SSC Editor (11/18/2011)
Grant Fritchey (11/18/2011)
My title is Product Evangelist, but my job is Booth Babe.Babe, bouncer, or barbarian?
In that kilt?
yes!
Exactly.
November 18, 2011 at 8:54 am
Daryl AZ (11/18/2011)
I was questioning whether switching from a clustered index on an Identity to a clustered index on non-sequential keys would affect...
November 18, 2011 at 8:53 am
I would strongly recommend having a clustered index on the table. It doesn't have to be the primary key, but by and large, in most circumstances, a table with a...
November 18, 2011 at 8:40 am
Gianluca Sartori (11/18/2011)
Grant Fritchey (11/18/2011)
Gianluca Sartori (11/18/2011)
The technique described there uses DBCC commands,...
November 18, 2011 at 7:19 am
Gianluca Sartori (11/18/2011)
The technique described there uses DBCC commands, but it works with...
November 18, 2011 at 6:27 am
That's just so open-ended... How are you at query tuning? Are you an SSIS expert? What about hardware, do much with hardware? Networking? Virtuals? SANs? Performance Monitoring? Operating Systems? The...
November 18, 2011 at 6:24 am
You can't alter that out of a table. So, you have to create a second table with the structure you want, copy the data across, drop the original table, rename...
November 18, 2011 at 6:16 am
I'm not even going to try to wade through all that.
Here's a question. How many rows are returned by that multi-statement table valued user defined function? I ask because, if...
November 18, 2011 at 6:14 am
You can also enable traceflag 1222 which will output deadlock info to the error log in SQL Server whenever a deadlock occurs. This is frequently easier than trying to capture...
November 18, 2011 at 6:09 am
You can do network backups. As long as the the SQL Server service account can see the location that you are backing up to, you're golden.
However, be sure of the...
November 18, 2011 at 6:07 am
If the internal proc returns a data set... there's not much you can do. What is it that you're trying to do with the procs?
November 18, 2011 at 6:05 am
Viewing 15 posts - 11,641 through 11,655 (of 22,214 total)