What's the size of your database ?

What's the data size in your database ?

What data size are your databases and what size is your load on a daily basis ?

Maybe work out a scenario where you take full backups of a couple of...

your whole object already resides in memory, so no physical reads needed.

Tempdb doesn't just use model.

have a look at:

select *

from sys.master_files

where database_id = 2

:w00t:

I haven't had the need to revert to sp2, but at this time I would investigate if the issues your team experiences are addressed in SP4 ( or the available...

Chances are your log file cannot be extended within the timeout sqlserver waits for the os to complete the task.

SQL will then raise the error file full, but the os...

it is a good practice to pre-size your database files.

With ssms you can expand your file(s) using the object browser, right click on the database name, click properties, click...

That is great news.

This may get me in SSCs March Madness hall of fame :w00t::hehe:

Keep in mind when updating statistics, don't include the statistics of the indexes you've just rebuilt !

An index rebuild does a 100% scan and stats update for this index. (...

I'm sorry, this thread lost my attention ... or how should I put it 😉

Did you try:

UPDATE T

SET A_ID = A.ID...

probably your sqlserver service account doesn't have auth to your source and/or target folder.

IMO it is better to use a sqlagent for this purpose because you can easily define a...

how about

;

;

with cteTbHierarchy

as ( /* Select all table without (selfreferencing) FK */

...

Once again has been proven simple rocket science is what it takes to get lucky.

I extrapolated Pauls (sql_kiwi) "Constructing a Plan series", Gails Indexing articles, Jeffs Anty RBAR laws and...

Most of the times that is a good thing ;-):w00t:

also keep in mind MSDTC needs some authentication settings shut off when connecting from or to Windows 2000 !