Viewing 15 posts - 3,751 through 3,765 (of 9,643 total)
Get to know Books On Line (BOL) it is your friend. You expand databases using the ALTER DATABASE statement. Something like this:
-- determine file name and current size
SELECT
...
November 24, 2009 at 8:04 am
What is the definition of the IX_QueueData index?
It looks like the AND itemType = @itemType in the WHERE clause of the UPDATE statement is commented out, is it?
Is the insert...
November 24, 2009 at 7:51 am
DO NOT use TRUNCATE_ONLY! If you are mirroring you need the transaction log. The ONLY thing that allows the log file to be wrap when in FULL recovery...
November 24, 2009 at 7:45 am
If you are on SQL Server 2000 as the forum implies, I think your only choice is to setup a server-side trace[/url]. Then you can query the trace file...
November 24, 2009 at 7:40 am
I think you want to look at a CROSS JOIN. A CROSS JOIN creates a Cartesian product, one row for each combination of data. In your situation I...
November 24, 2009 at 7:24 am
So what are you getting NULL's in? The entire row or specific columns?
November 24, 2009 at 6:57 am
Bob,
Be more than willing to look at the article. I think you have my email. If not pop me a DM and I'll send it to you.
November 23, 2009 at 12:16 pm
Not much you can do here if that is the combination that ensures uniqueness.
November 23, 2009 at 10:28 am
Matt Miller (#4) (11/23/2009)
By the way, I'm sorry I missed the candle and cakes, but -Happy 1st birthday to the Thread.
That's right - the Thread turned 1 last week.....
Not...
November 23, 2009 at 10:23 am
There are several out there. 2 I recommend are (in no particular order):
1. Ola Hallengren's script which is part of his entire maintenance solution at http://www.ola.hallengren.com[/url%5D
2. Michelle Ufford's...
November 23, 2009 at 8:35 am
Using UNION ALL is certainly a step in the right direction. Without having a better understanding of the structures and data it is hard, at least for me, to...
November 23, 2009 at 8:28 am
I second this, and I think I actually had mentioned it somewhere else before.
November 23, 2009 at 8:23 am
Hey Grant, I think this one would be a good one for you as it is about how the optimizer picks which table to use as the outer table in...
November 23, 2009 at 8:19 am
I don't know this for sure, and I think someone like Grant Fritchey might be better equipped to answer this question, but I'll give it a shot.
In the example you...
November 23, 2009 at 8:18 am
Check out the permissions section in the BOL entry for sys.columns. BOL is a great resource and can answer most of your questions.
November 23, 2009 at 8:09 am
Viewing 15 posts - 3,751 through 3,765 (of 9,643 total)