Viewing 15 posts - 32,731 through 32,745 (of 49,552 total)
mathewspsimon (5/26/2010)
yes i am working on 2005 but dont have much idea about the newer stuff.
Then look at this as an opportunity to get familiar with one of the 'newer'...
May 26, 2010 at 7:05 am
karthikeyan-444867 (5/26/2010)
First, what actually makes you say that and why are you "sure"?
I read like 'Don't create clustered index on monotonically increasing column' some years back.
I take it you didn't...
May 26, 2010 at 5:50 am
karthikeyan-444867 (5/26/2010)
int identity for a primary key is nothing but unique clustered index.???
By default only.
May 26, 2010 at 5:38 am
Look up PIVOT. Start with the SQL Books Online (sql help file)
May 26, 2010 at 5:05 am
Insert... values cannot have a where clause, as there's no query to apply that where to.
May 26, 2010 at 5:04 am
Jeff Moden (5/26/2010)
Ken Lee-263418 (5/25/2010)
May 26, 2010 at 5:02 am
Oksana March (5/26/2010)
GilaMonster (5/25/2010)
Oksana March (5/25/2010)
I know memorizing the answers...
May 26, 2010 at 3:11 am
Thread continues here - http://www.sqlservercentral.com/Forums/Topic927956-360-1.aspx
No further replies to this thread please.
May 26, 2010 at 1:32 am
Ken Lee-263418 (5/25/2010)
1. All binary trees of all indexes only keep the first field defined in the index.
Maybe I'm misunderstanding you, but...
If you have a composite index (index defined on...
May 26, 2010 at 1:23 am
don.schaeffer (5/25/2010)
May 26, 2010 at 1:17 am
Lynn Pettis (5/25/2010)
Trey Staker (5/25/2010)
Steve Jones - Editor (5/25/2010)
I don't understand how he got any degree with the lack of desire/ability to look things up himself.
It may just be a...
May 25, 2010 at 2:33 pm
From http://www.sqlservercentral.com/Forums/Topic927200-338-1.aspx
lmu92 (5/25/2010)
I'm confused....If you can't explain the benefits of the fine tuning
weyou did, then why there was a need for tuning in the first place?
😀 :hehe: :w00t:...
May 25, 2010 at 2:13 pm
Start with this - http://msdn.microsoft.com/en-us/library/ms188336.aspx. The performance stuff that I wrote (link Lutz posted) can wait until you understand what they do.
Once you've gone through that (and experimented with code),...
May 25, 2010 at 2:12 pm
Steve Jones - Editor (5/25/2010)
I don't understand how he got any degree with the lack of desire/ability to look things up himself.
Damned if I know.
May 25, 2010 at 11:00 am
Howard.Veazey (5/25/2010)
BTW...On the RAISEERROR that you originally said was not firing...It won't...The reason is the logon trigger fires *after* authentication but *before* actual connection, so it can't fire...
It will fire.
The...
May 25, 2010 at 10:48 am
Viewing 15 posts - 32,731 through 32,745 (of 49,552 total)