To use a system function that already does what you have coded.

try master.sys.fn_varbintohexstr( cast(int-value as varbinary(max)) )

Bloody iPhones. Exec toys and everyone panders to them.

This is now like a newspaper where the article is split up so that there is a bit on every page. (Too...

Patrick Ge (6/19/2013)

---

Thanks for sharing. I have a similar monitoring in place using event notification but it's much simpler than yours. I only monitor changes to functions, stored procedures for...

If you end up with some excessive table growth.

eg. Replication may be updating statistic regularly, rapid table drop & creates they can be excluded by adding

if (condition)

begin

...

Why even spend those few minutes?

Simply add the '-SkipErrors' parameter to the distribution agent startup call.

Then it doesn't matter which article it is causing the problem.

http://technet.microsoft.com/en-us/library/ms151331%28v=sql.105%29.aspx

The errors will be logged,...

Grant Fritchey (5/31/2012)

---

Alex-668179 (5/31/2012)

---

"every table within SQL Server should have a clustered index"

Fine, but should it then also always be the (preferably meaningless?) primary key? Or an index that is...

table locks are the killer here...

Lock escallation happens @5000 rows, keep batch sizes below this

select 1

while @@rowcount > 0

delete top 4999 from ...

(or something similar)

Also you're...

This doesn't cover the cross-instance collation issues.

Using the default configuration for Linked-Servers will give you no end of headaches.

By default, the collation is eqated to the collation of the remote...

Compression does not work well on any data stream < 150 bytes (+/-)

For most techniques the first 100 bytes, or so, are used to store header information to reverse the...

I'll defend it! 😛

ALL my developers have to put up with it.

Frankly I want to...

Yes,...

This works if you are the ONLY one using the database.

Running in a production system you can't just go about changing the recovery model.

as for a 'batch' delete

select 1

while @@rowcount...

Of course this all falls in a screaming heap when larger 'row selections' are used, and 'Lock escalation' kicks in.

A selection of 5000+ rows - will escalate to a single...

TheSQLGuru (4/28/2009)

---

Well if you change the code - ie the data type - of course you...