Viewing 15 posts - 17,011 through 17,025 (of 22,210 total)
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
I hate to pop everyone's bubble, but wasn't it established a while back that the 666 number is either a mistranslation or a bad copying job and tha thte actual...
July 14, 2009 at 9:22 am
It really depends on the configuration of your tables & indexes, but if the IN clause is causing poor performance, you could try creating a temp table, load the variables...
July 14, 2009 at 6:42 am
Bruce W Cassidy (7/13/2009)
Grant Fritchey (7/13/2009)
You mean if you change fonts you get better performance? Holy smokes! I've got to get some edits into the chapter on tuning...
[font="Verdana"]I'm also thinking...
July 14, 2009 at 5:34 am
jcrawf02 (7/13/2009)
Paul White (7/13/2009)
GilaMonster (7/13/2009)
Done, apparently, because 'null' is faster than NULLBut only if you use little letters (less aerodynamic drag = faster!)
...then he should use cursive...
You mean if you...
July 13, 2009 at 6:52 pm
Viewing 15 posts - 17,011 through 17,025 (of 22,210 total)