Yesterday it also happened to me in a server that will be in production in a week, so I could do all the tests I want now. I wasn't at...

It would be nice to know the space used and the space available too...

Greg Charles (12/17/2008)

When using log shipping or db mirroring, the receiving server doesn't need a seperate license as long as it remains passive. If queries are run against the...

In fact, using LINQ to SQL, or Entities without Partial classes can be quite painful, I think. It's nice when you want to create functions to get data filtered, for...

Nice question 🙂

Usually I do myself and I get Gail answer: better the composite key solution. A reason I've is that probably a large number of queries will be to...

I was asking myself the same question. Because although they are different they're used for quite the same (High Availability), but I don't know which one to use.

In a SAFETY...

Nice Ad. You should have included the price and licence in the article.

Anyway, I think that if you just use stored procedures, it can be a good idea, but...

Is it possible to log the RAISERROR messages into a table and not just to the Windows Even Log?

I've some stored procedures with the following line:

...

If it's a Express Edition or you've changed the installation directory, before you have to run this:

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REINSTALLMODE=v

Hope this works to you too 🙂

Josep.

I think it doesn't work when there's BLOB fields (at least with IMAGE type) in SQL Server 2005.

I prefer the simple queries (just an INSERT, UPDATE, DELETE) to be done directly from the application. But when there's a lot of queries to do at the same time...

If you want to use SQL instead of other applications and you're using SQL Server 2005, why you don't use the extended procedure xp_delete_file?

Personally I feel it quite restricted and...

I'm 27 and I've been working with SQL Server for 6 years now and .NET for 2. I'm quite specialized and sometimes I get worried thinking how fast the IT...

As mojo said, it would be a great think to know wheter the hotfix is public or not.

And I'm also having the same question as Martin Vrieze had. Is it...

I've also enjoyed the article.

It's very clean to do that in this way. There's no need to do it in .NET 🙂

I also suppose that it performs much better...