Avoid using MAX + 1, really...! This way seems to work with one user in a test environment but it's no solution for production system. First issue always selecting MAX...

Hi

You can find a couple of approaches as articles on this side:

monitoring articles

Greets

Flo

Hi

Here you can find an about data compression:

SQL Server 2008 and Data Compression[/url]

Greets

Flo

Hi Phil

Can't reproduce this. Just tried the following SQL file:

PRINT 'Hello world';

GO

PRINT 'Hello new world';

GO

SELECT TOP(1) TABLE_NAME FROM INFORMATION_SCHEMA.TABLES;

GO

SELECT TOP(1) TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS;

GO

which returns all output by using "sqlcmd -i...

Hi Michael

If your xml is not too large you can load it into a MemoryStream and use a HttpRequest to send it to your server. In other case you have...

Try this

http://www.developer.com/db/article.php/3390241

I don't like cascade delete foreign keys because they can affect hidden huge data operations. My suggestion is an own, custom delete procedure.

Hi (and welcome at SSC 🙂 )

Two things I changed.

* Don't use nested JOINs when they are not needed. I moved your nested joins up to the FROM clause.

* Keep...

Some suggestions

1.) Is .NET 3.5 installed on your server?

2.) Is your assembly compiled as "Any CPU" or "x64" assembly?

3.) Did you try to add System.ServiceModel.dll manually as assembly?

Here another thread...

Sounds like a caching problem. CLR functions are implemented as "static" Method. If they use caches within those modules those caches will not be freed until SQL Server unloads the...

I've no idea how to boil a perfect egg, but you should use a CLR-split when it's done

:hehe:

Wouldn't exist, too. CSV and Excel are just a lousy kind of a...

I don't think that this is a problem since the index tree is maintained without the data structure and points to the row, not to the column.

Probably here are storage...

PiMané (9/8/2009)

---

Is it a good idea not to have a CLUSTERED INDEX, since the PK uses GUIDs, or should I create one using an Id column, BIGINT - IDENTITY(1,1), (used...

Marcin Gol [SQL Server MVP] (9/7/2009)

---

maybe other question is right here ... does the implemantion of checksum function has changed over the time ? (sql 2000 -> 2008?); if don't...