Was sure about other three answers but not sure about

Running DBCC CHECKALLOC or DBCC CHECKCATALOG

I executed them on all SQL Server versions and it could be executed successfully on...

Stanley Chan

Sanjay,

It doesn't matter how the pagefile defined in Clustered environment.

e.g. Node A has a 2GB pagefile in C: only, node B has a 4GB pagefile in D: only.

If the...

this was easy.

I had to change it to 6 GB from default size of 2 GB on a production server few days back. Also, by default pagefile.sys is located in C:\...

Interesting question and good explanation.

For a normal person 3 and 3.0 is same. programming can be manipulative.

Yes you can insert but should be avoided by having a unique constraint or Pkey on identity column.

Since, it doesn't make much sense, if you want to put...

I still had one production server which is still running on 6.5 version and one on 7.0 version. Still, HR dept. wants to keep their data in 6.5 only....

It's introduced in 2005 version, but partition is supported only in Enterprise edition. On other editions you will get...

This was easy.

Very informative article. Thanks Dave for compiling it, thoroughly.

I am sure my current company / project would not be using it in near future. But, still good to...

Good question Hugo. I missed . in Round. Still a lot to learn.

Good one.

execute as Login is new to me. Hadn't tried as of yet, but would definitely suggest developers to use this while working with multiple schemas.

Nice question.

When the length is not specified in a data definition or variable declaration statement, the default length is 1 ----- Didn't knew this. used to give length to...

As the DBA was on vacation ................ Huh. No way. My manager would give me a call to make changes no matter if I am sitting in...

these 10% stats works good with large databases. For small database with less than like 50 MB it will never show 10,20,......100. Try it for large DB with...