Viewing 15 posts - 1 through 15 (of 84 total)
You could make a view with all 4 queries "union all"-ed together and add a derived column for the database name, that way you can just do your query and...
May 11, 2012 at 12:41 pm
Nadrek (5/6/2010)
So, we have a table, with pages, and a clustered index:
Page 1 contains a-b
Page 2 contains...
May 6, 2010 at 4:14 pm
The part of me ready for trick questions missed the part about NCL having CL pointers in the IX pages. I thought "well, only the leaf level pages have...
May 6, 2010 at 4:03 pm
That did it. I was assuming migration meant simply moving. As it turns out, I converted to a SSIS package. I did export/import and that took care...
June 19, 2009 at 9:57 am
Steve Jones - Editor (9/28/2008)
September 29, 2008 at 8:29 am
RockStar (6/10/2008)
I recently did a reorg of indexes and update to stats...
June 11, 2008 at 2:47 pm
Hey Matt,
Have you considered updating all columns at once?
[font="System"]UPDATE Vids
SET CategoryID = COALESCE(@CategoryID, CategoryID),
VidFileName = COALESCE(@VidFileName, VidFileName),
...
WHERE VidID = @VidID[/font]
Thanks,
Eric
June 9, 2008 at 3:24 pm
mtassin (4/24/2008)
We can always rewrite the question.Does Windows XP by default come with Exchange Installed?
A. Yes
B. No
C. If you install Windows 2003 Server over it and then install Exchange
I give...
April 24, 2008 at 12:28 pm
Or do we just concede to Intel and it's imitator AMD?
I would like to ask Steve who made the x64 instruction set that everything is moving to in the...
April 4, 2008 at 8:24 am
Good points about the job failure logic. In general, if we ever have a job that fails and then sends a failure notification, we have that job step exit...
February 11, 2008 at 3:55 pm
Hey Dave,
Grant has a good point about not guaranteeing referential integrity. The extra columns you have are purely auditing columns. If you removed them, you wouldn't know who...
February 11, 2008 at 9:55 am
Interesting solutions. For large environments, enterprise monitoring software is very useful. Our environment has 200+ SQL instances and we use NetIQ. We finished up a project that...
February 8, 2008 at 11:48 am
Hey Jeff,
Would it be possible to post the specific error as well? If there is no error, is there anything else that you find odd or notable?
Thanks,
Eric
December 31, 2007 at 12:31 pm
Hey Molly,
I would use the convert function as you suggested, but you would not want to use INT. You will want to use the decimal data type. Depending...
December 31, 2007 at 12:27 pm
You are very close.
[font="System"]declare @current_db sysname;
set @current_db = db_name();
select 'The current DB is ' + @current_db;[/font]
Thanks,
Eric
December 31, 2007 at 9:21 am
Viewing 15 posts - 1 through 15 (of 84 total)