Our DBA has this question: When we set the Recovery Model to "Full" for the msdb database in SQL Server 2000.. After a reboot it sets the Recovery...
[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />I have been frequenting this site these days and I think it is great.<br /><br...
I have read in one of the posts that use Select * is inefficient.. I was wondering what the experts' opinion would be...[8D] You see, when we do...
<br />What exactly are these stored proc dt_*<br />eg<img src='/community/emoticons/emotion-2.gif' alt=':d' />t_getpropertiesbyid_vcs_u<br />...
<br />I need to move the log file of my SQL Server 2000 database to another <br />drive. <br /><br />I detached the db <br /><br />Copied to log fle...
I need to move the log file of my SQL Server 2000 database to another <br />drive. <br /><br />I detached the db <br /><br />Copied to log fle over...
We have decided to break our database into two filegroups each running on a seperate disk spindle. filegroups: PRIMARY, SECONDARY The SECONDARY...
When we create a 'clustered' index with just one cloumn, isn't it just the same as a 'non-clustered' index? SQL 2000, creates a clustered index as a...
Separate names with a comma.
