Hi,

1. The actual benefit of the partitioned table will be achieved only when you place the partitions in different file groups and each file group in different disks.

SQL...

Wht can't you do that?

What is the error you are getting?

You also need to consider, updating the records in small chucks at a time. Even though it will take more time than usual, the rest of the table will...

I believe some of the tags I used within the code doesn't work with the editor. Please add the Tablename in those places..

From your mail I understand you already have the table with data. That adds complexity to the work you have.

If you want the starting character of the last name to...

Hi Steve,

Nice article. I have my doubts over the point where systems actually had permanant tables owned by actual users..

As far as I know, People have get...

you can find a lot of information on C2 auditing over the web.

Some of the articles, which I found useful are

http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/

http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx

Hope these are useful to you too!

Hi

Did you add a drive, copy, replace or rename any data files files when the SQL Server was stopped, or the databases were offline? The message shows that SQL...

As Clustered Index has the leaf level stored with data pages, when you need to read other columns by Clustered Index, you don't have to do a separate operation. ...

You can use CmdExec method (Using operating system command) also to run the command.

To Use the extended stored procedure xp_cmdShell, it needs to be enabled. By default it...

C2 Auditing is handled through trace events. I prefer to use customized trace (store them to a file.)

You...

I can see a few issues with MOCK tables:

1. Extensibility:  If different information is kept in one table, and if after a few years you find that you have to...

Congratulations to Don. Even though your writing style has taken a bit of time for readers to understand, you have created a hurricane among the readers.  I won't be surprised if this article gets the...

It is a great surpise to see that in sql2k5 we have lost the fucntionality to script a set of objects based on the settings i want.  In sql2k,  I...

Hi,

I am not sure of your question.  Do you want to find the procedures run during startup or the procedures currently running?

to Find the procedures run during startup, you can...