Viewing 15 posts - 37,456 through 37,470 (of 49,566 total)
dh (7/24/2009)
1. Should I run the 'DBCC SHRINKFILE' command against the log file and/or 'BACKUP LOG name with TRUNCATE_ONLY' to get the log file down?
Maybe and no. If you run...
July 24, 2009 at 12:15 pm
Lynn, yours is not equivalent if MyField can be null.
July 24, 2009 at 12:11 pm
allen davidson (7/24/2009)
I thought that it keeps rows with adjacent clustered index entries, subject to space being avaiable on the page, on the same leaf page.
It does.
Let's take an example...
July 24, 2009 at 11:14 am
jcrawf02 (7/24/2009)
By the way Gail, never officially thanked you (thank you, thank you, thank you!) for the link to Leigh's WOT Re-read.
Pleasure. I love her writing style.
I'm way behind,...
July 24, 2009 at 10:59 am
Jeffrey Williams (7/24/2009)
I wonder what it says about me that I actually enjoy reading all of these books that are supposedly targeted at teens? :hehe:
I'm the same. I find...
July 24, 2009 at 10:57 am
allen davidson (7/24/2009)
Because a clustered index determins the physical order of records on disk....
Clustered index determines the logical order of the data, not the physical. Rows can be stored physically...
July 24, 2009 at 10:04 am
A clustered index has to be unique. It's the row's 'address'. If the clustered index is not declared as UNIQUE then, behind the scenes, SQL adds an integer column to...
July 24, 2009 at 9:43 am
Do you have the source code for that trigger?
July 24, 2009 at 9:20 am
Why do you say the cursor is unavoidable?
Can you explain what this does?
July 24, 2009 at 8:37 am
Look up EXECUTE AS in Books Online. There are a lot more options than just EXECUTE AS OWNER.
July 24, 2009 at 8:26 am
jordon.shaw (7/24/2009)
Is there a way in SQL to do like a runas?
Look up EXECUTE AS
July 24, 2009 at 8:15 am
Paul White (7/24/2009)
1. ...
July 24, 2009 at 8:05 am
I keep running into people who have SQL 2005 on Vista, somehow missed the provisioning tool that launches at the end of the SP2 installation and then can't log into...
July 24, 2009 at 6:18 am
The exams for the MCDBA cert were retired a long time ago and there's no longer any way to get that cert. Rather look at getting MSTS and MCITP for...
July 24, 2009 at 6:13 am
Viewing 15 posts - 37,456 through 37,470 (of 49,566 total)