missed it. Was coaching in Salt Lake when it went by.

Did see the...

Just a quick update on this, the issue seems to have resolved by adding additional CPU and memory to the server and adjusting the MAX SQL memory to use...

Are you really using SQL 2000 or SQL 7?

In most cases, you don't need to stop your replication jobs (like the log reader and distribution agent) when running regular maintenance tasks like backups, re-indexing, or even DBCC...

InterContinental Chicago Magnificent Mile is right down the street from Grant Park.  There's some kind of wise-guy comment in here I think.

Logins are present always - been running Mirrored dbs for a decade. The dbs are on the "dedicated Mirror" instance for a day or so on the weekend and...

I have transactional replication setup in SQL 2022. I have a distribution server running push subscriptions to subscribers. I'm trying to figure out if I need to stop replication...

Thank you guys for your valuable inputs ! So my first approach would be to increase processor count from 4 to 8 and memory from 16 to 32 GB....

Thank you guys for your valuable inputs ! So my first approach would be to increase processor count from 4 to 8 and memory from 16 to 32 GB....

You need to generate the scripts to create the logins, and do a find and replace of the old domain and...

Hello - rather new to this feature and looking for advice. So, I have existing CNAME records in our test environment that are used in the connection strings as...

What reason do you need to rebuild these indexes?

Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes...

Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes...

Oh my.  I can only imagine.  Any chance of you sending an email about that? ...