Viewing 15 posts - 45,721 through 45,735 (of 49,571 total)
kiran (7/14/2008)
I have posted in different forum
Please don't cross post. It just wastes people's time and fragments replies.
Replies to th following thread please
http://www.sqlservercentral.com/Forums/Topic533714-145-1.aspx
July 15, 2008 at 1:28 am
It's an index enforcing the primary key. To drop it, you will have to use ALTER TABLE ... DROP CONSTRAINT rather than DROP INDEX
July 15, 2008 at 1:27 am
They are unrelated terms.
A primary key is the identifier of the row. It must be unique, it must have no nulls and it's used to enforce the entity integrity of...
July 15, 2008 at 1:24 am
shahbaz.oradba (7/14/2008)
take backup of T log with this option.WITH TRUNCATE_ONLY
In simple recovery mode (which the OP's database is in), the log automatically truncates on checkpoint. Hence there is no...
July 15, 2008 at 1:18 am
shahbaz.oradba (7/14/2008)
Hi,how can we know that particular query is taking long time and we have to optimize that,and i heared that query optimization through sqlserver profiler degrades the perfomance.?
Sorry, I...
July 15, 2008 at 1:13 am
brdudley (7/14/2008)
There is a slight difference in that the Where clause is evaluated after the Joins have happened.
Order of clauses depends on the plan the opimiser chooses. Sometimes the...
July 15, 2008 at 12:06 am
shahbaz.oradba (7/14/2008)
your backup startegy should be
Backup strategies vary based on the size of the system, the available space for backups, the time allowed for restore and a number of other...
July 14, 2008 at 11:54 pm
Perry Whittle (7/14/2008)
this shrinking malarky has been done to death all over the forum:D
I know. That's why I wrote the blog post in the first place, so I didn't have...
July 14, 2008 at 11:48 pm
Generally, if you're deleting up to half the table (maybe even more) it's faster to save the rows you want, then trunate the table than to run the delete.
Less impact...
July 14, 2008 at 11:47 pm
David Griffiths (7/14/2008)
July 14, 2008 at 11:45 pm
JeeKay (7/14/2008)
DO you have the different types of Isolation Levels in SQL 2 K like 2005 ? I was not aware. I will try to do some reading on that....
July 14, 2008 at 11:28 pm
Guru (7/14/2008)
this sufficient for my hardware configuration plz any one to suggest me.
Depends what you're going to do with it.
I would strongly suggest a RAID array rather than...
July 14, 2008 at 8:15 am
Could you perhaps post the schema of the two Job tables and the definitions of the indexes that these example queries use?
What are the execution times of these selects and...
July 14, 2008 at 8:00 am
Viewing 15 posts - 45,721 through 45,735 (of 49,571 total)