Viewing 15 posts - 40,411 through 40,425 (of 49,571 total)
lmu92 (3/12/2009)
How can you be sure that the fragmentation question relates to indexing?
Context.
Why not Message Fragmentation in Service Broker? [Smile]
Why not File System fragmentation? Why not IP fragmentation? Why not...
March 12, 2009 at 10:55 am
prvreddy (3/12/2009)
Hi all,1)Why a table have maximum one clustered index ?
Because the clustered index is the table. The leaf pages of the cluster are the actual data pages of...
March 12, 2009 at 10:11 am
sql60190 (3/12/2009)
Sorry if I asked for too much. Forgot myself, really.
No worries. Asking isn't a problem.
As for the XML, make sure you're at least comfortable with it.
March 12, 2009 at 10:10 am
sql60190 (3/12/2009)
So, those of you who have taken this exam, how important is this subject?
Fairly.
That's about all that can be said without violating the exam NDA.
March 12, 2009 at 9:59 am
ALTER DATABASE [Test_db]
SET OFFLINE
WITH ROLLBACK IMMEDIATE
Kicks everyone out and takes the database offline. Then you can restore over without worrying if there's anyone connected.
March 12, 2009 at 9:54 am
Hemalatha (3/12/2009)
If...
March 12, 2009 at 9:52 am
Depends. If the static and non-static can be on the same page, yes.
March 12, 2009 at 2:34 am
barcode (3/12/2009)
...and you're from South Africa - me too! I'm impressed.
Whereabouts? If JHB, there's a usergroup meeting next week tuesday. Interested? (details on my blog)
March 12, 2009 at 2:33 am
Chirag (3/12/2009)
Do you mean to say u put indexes on the columns and the query worked better?
He's talking about a different problem that I advised him on yesterday.
March 12, 2009 at 2:21 am
Glenn Dorling (3/11/2009)
March 12, 2009 at 2:20 am
Those are 3 distinct indexes, they can't be merged into one. (Difference leading columns)
Just check in a dev environment that they are actually useful before you go creating them on...
March 12, 2009 at 2:10 am
arun.sas (3/12/2009)
Is same works in 2k? If no means, how these handle by other way in 2k?
No. DDL triggers are SQL 2005 and higher.
To prevent people dropping tables, don't give...
March 12, 2009 at 2:05 am
An index is not going to help you there. All of those LIKEs have leading wildcards. An index seek is not possible when there's a leading wildcard. That query will...
March 12, 2009 at 2:02 am
Host_name is the machine name.
March 12, 2009 at 1:56 am
Viewing 15 posts - 40,411 through 40,425 (of 49,571 total)