This is accurate. If you login with 'sa', and then change the password - you must disconnect that session and login again with the new password

Torn page - I'm using Guerrilla Glue - better than duct tape or superglue - and has many more uses.

As for the coding questions. A DBA does have a...

With this being a highly busy OLTP configuration and drive C should be for system files - safest bet is Drive D for all files.

Better option would be to purchase...

Which of the fields is the identity field? What are the datatypes for the remaining fields in your Key?

When comparing these queries, it is difficult to answer your question...

Is TicketID an identity field?

What kind of data is in ActDtim?

Since the clustered key is the three columns combined, and if you have datetime as the data type in ActDtim,...

Two bits

I like to throw in some good code and bad code samples. You pick out which one works better and tell me why. Or I will just...

You can also run the full backup and split the BAK file in small chunks using winrar or similar tools. Then send each mini file via WAN to the...

current version

with tablesize as (

select so.Name as TableName

,TableSizeMB = convert(decimal(15,2),si.dpages *8 / 1024)

,IndexSizeMB = convert(decimal(15,2),sum(isnull(si2.used,0))*8 / 1024)

,TotalSizeMB = convert(decimal(15,2),(si.dpages * 8 /1024) + (sum(isnull(si2.used,0))*8 / 1024))

,TableFreeMB = convert(decimal(15,2),(si.reserved * 8...

Also keep in mind performance of Table Variables versus Temp Tables. Use the appropriate one for your need and size of data that will be used. Test first...

No. If you kill it, you will encounter the rollback.

I would recommend breaking up the job into smaller chunks so that it doesn't process as much at once, or...

Updated query, but still looking for the ability to find the allocation of each table to each file in the filegroup.

So far it is not looking too promising.

Thanks - that is the route we decided to take. Much more time consuming but is the best in the end.

I considered moving all tables already. In fact we are already in process of doing that. The only issue with it that I see is that it doesn't...

This was pretty close to an automated solution.

In testing with a new puzzle not provided in the article, the first quadrant was all muddled up. The solution provided was...

Pyramid schemes are illegal - and matrix, unilevel and binary trees could all be a pyramid scheme. The Fed monitors MLMs closely and makes sure they are in compliance...