Viewing 15 posts - 17,011 through 17,025 (of 22,214 total)
Without a lot more details, it's hard to know for sure, but on a guess, you've got the GUID clustered. That's going to lead to huge amounts of page splits...
July 15, 2009 at 7:03 am
There must be a function or something that's radically changing the execution plan. You'll need to post both execution plans and please make them actual execution plans, not estimated.
July 15, 2009 at 6:59 am
Instead of intentionally violating the key (not something I'd encourage), why not just change the query slightly so that it selects the TOP 1 value and inserts that? You wouldn't...
July 15, 2009 at 6:56 am
A backup of a database is just a file, so you can move it any way you want. Copy & paste, as mentioned before will work. XCopy will work. If...
July 15, 2009 at 6:53 am
You need to ensure that all connections are clear with the database you're attempting to restore, even your own. Once all the connections are clear, you can restore.
If it's an...
July 15, 2009 at 6:51 am
There is no way to update multiple tables from a single TSQL statement. If you want to update multiple tables, you will need multiple statements. I'm not sure that you'd...
July 15, 2009 at 6:44 am
Assuming that you're working with SQL Server 2008 since you posted to this forum, you could also look at using the Hiearchy data type. That's for establishing Parent/Child type of...
July 15, 2009 at 6:41 am
Jan Van der Eecken (7/14/2009)
GilaMonster (7/14/2009)
Jan Van der Eecken (7/14/2009)
Are you saying I'm out of the office at an inapproriate time?
It's 10pm. What self-respecting IT person is not still working...
July 15, 2009 at 5:36 am
I agree. That's a pretty poor choice for design. Not to mention the horrible chattiness of the app on your network, it's going to cause some major league contention within...
July 14, 2009 at 1:23 pm
RBarryYoung (7/14/2009)
Grant Fritchey (7/14/2009)
July 14, 2009 at 1:18 pm
GilaMonster (7/14/2009)
Grant Fritchey (7/14/2009)
No kaboom.No boom today. Boom tomorrow. There's always a boom tomorrow.
:-D:-D:-D:-D:-D
One of my favorites:
You're sitting at my station, using my equipment. Is there a reason for this...
July 14, 2009 at 12:37 pm
Oooh, look... pulling the pin...
July 14, 2009 at 12:13 pm
It could be bad or missing indexes. It could be that your process is blocked by others. It could be simply resource contention.
Hard to know with out quite a bit...
July 14, 2009 at 10:38 am
If we are coming up on the number of the beast & the end times & all that because of the Thread, then the four horseman & the anti-guy must...
July 14, 2009 at 10:00 am
Viewing 15 posts - 17,011 through 17,025 (of 22,214 total)