Of course, if MSSQLSERVER runs under a domain account you should be able to use the debugger within QA.

Open up the object browser in QA, right click on the proc...

Great thanks, I think the FILLFACTOR and PAD_INDEX are prime candidates for an article.

So a page split is expensive because it copies half the records from the last page into...

The thing to remember with security is who and what are you protecting the server from.

In our case SQLMail can only be used to send internal mail and can only...

I am still not 100% clear as to how to decide the FILL FACTOR.

My understanding was that if you have a high input rate into a table then the indices...

Do you allow mail to go into your SQL Server or are you simply pushing messages outwards?

Our network guy installed Outlook but configured the Exchange server so that only internal mail...

I work in a development environment where data is relatively small, even when we do data migration jobs.

This gives me the luxury of running DBCC DBREINDEX as part of the...

Check for locks.

It may be that you stored procedure requires a lock on an item that is already locked.

I take it that your publication includes the stored procedures, not just the tables?

The quickest way of reassigning pemissions is to assign permissions to a role then use TSQL Script...

DECLARE @sSQLSELECT VARCHAR(8000)

DECLARE @sSQLFROM VARCHAR(8000)

DECLARE @sSQLWHERE VARCHAR(8000)

SET @sSQLSELECT='SELECT .......'

etc

EXEC( @sSQLSELECT + @sSQLFROM + @sSQLWHERE)

Think of the BEGIN and END statements in TSQL as being like the curly braces in JavaScript, C#, C++, C, Java etc.

BEGIN = {

END = }

As with these languages TSQL...

If possible I try and avoid SHRINKFILE in live systems because there is an overhead in growing the file as data is put back in.

There is no direct equivalent.

You could try using the TOP predicate to return the TOP 1

The users within a database have a SID column which matches to the SID value of the login.

If you transfer your logins first then restoring your database will maintain your...

Yep, no DRI.

A few years back there was an discussion on this site about leaving out DRI in order to get the maximum throughput on the database. 

The example given...

In the particular vendor database (I stress vendor) it held a list of countries.

The problem you face with a database with thousands of tables are

• Comming up with a meaningful, common-sense...