i have always used SQL Server IO Simulator. Its free from Microsoft.

http://support.microsoft.com/kb/231619

If you need to test your app code as it pertains to the database, you need to...

Nice article Kim. I like how you make your email notifications with html encoding to make it pretty. Something I like to do also. 😀 😀 😀

Awesome article. Thanks for the effort, Jeff.

it requires down time. do it now.

http://walter.thyselius.org/data/howto/vmware-expand-windows-disk.html

yes. even though you choose to install on D:, a little bit of stuff still lands on C:. mostly shared components. small amount of data.

as a side note, 20 GB...

be careful if you are running that mirror with a witness server. I have seen mirrors fail over during such routines. re-index is extremely log intensive. if your network /...

its telling you that the first DB that is running log shipping is using that directory.

when you add the second DB to the same directory structure, the delete function will...

nice article. I like the ability to schedule the scan with the agent. Will be very helpful @ my current employer. Thanks.

Hey Vadim,

thanks for the script. however, it presents a bit of a problem when you have multiple instances on a server.

it also does not account for 'other' CPU hogs. i...

currently, the company i am at has everything running on VM's. the ESX servers all have 32 GB of RAM each and SQL is given anywhere from 16 GB...

is column closedate a datetime datatype?

if it is not, you will have to do something like this;

where [closedate] > CONVERT(VARCHAR(10),getdate()-30,121)

and [closedate] < CONVERT(VARCHAR(10),getdate(),121)

or

where [closedate] > CONVERT(VARCHAR(10),getdate()-30,111)

and [closedate] < CONVERT(VARCHAR(10),getdate(),111)

depending...

some one at one point installed SQL Trace Analyzer

http://www.lakesidesql.com/products/sql_trace_analyzer.html

Great article Gail. Thank you.

have you "Enabled" the mail profile under the SQL Server Agent...

Open SSMS -->

Right click on SQL Server Agent -->

Choose Properties -->

choose Alert System -->

put a check mark on the Enable...

williamaffandi (2/7/2011)

I have some trouble exporting a table with a varbinary(max) column in it.

The table currently have 530 rows ( and expanding)

Each of the varbinary(max) column have around 44000 characters.

And...