do this in the exec sql task object:

<statement here>

GO

<statement here>

Go

and continue as you need to for any statement you like. Always test to ensure errors are propogated as you...

haha.. had the same thing happen to be Andy around 2 years back 🙂

I also keep 3 days of FULL backups and 5 days of logs (because they...

Hi

This is a catch 22 really, space vs recovery speed, the recovery time increases because you now have to uncompress files, have you timed this? you may be supprised...

Hi there

Did you try:

dbcc shrinkfile

dbcc shrinkdatabase

I did this the other day and all worked a treat.

Cheers

Chris

Hi all

Here is the query to get current connection memory usage as a point in time reading. From testing it doesnt seem to measure tempdb usage for the connection...

Hi guys

Well ill tell you where all is came from....

I am currently using SQL*Probe (great tool btw)... and they have a graph showing total user memory at a point in...

Brian

Here is another classic problem... in a recent system consolidation I ended up with 6 or so tables that shared the same name but in different case. Perhaps a...

Andy

Why not?? 🙂 i have a interest in understand the sqlserver kernal and how its going about allocating and using its memory structures, this is very handy when clients...

Hi

This is a bog basic trace, tracing sql that has a duration of more than 4sec. The trace includes the text, read, write totals.

Cheers

Chris.

Brian

Here is another script to list all columns that have a "char" datatype where they possibly should be "varchar".

select sysobjects.name, sysusers.name, syscolumns.name

from syscolumns, sysobjects, sysusers

where syscolumns.type = 47

and syscolumns.id...

Thanks guys, I will monitor page splits and go from there. I rebuild indexes every sunday at 11pm. A lot of tables have their own natural keys rather...

Brian

Great article Brian, only things worth adding:

a) FK columns that are not indexed

b) Cluster indexes on identity columns

c) No collected or stale statstics

Cheers

Chris

Hi there

As im also an Oracle DBA, I have an 8.1.6, SS2k and a mysql database running on my home box without any problems. I have yet to visit...

Hi guys

Not exactly what you were talking about, but we have an app where the developers pull out a lot of data from the DB, then wrapper it with XML...

Hi

I personally wouldnt bother even trying, and if it was available I wouldnt use it. "Boolean" is DBMS specific, and migrating between systems will be problematic for you. ...