I think we Southern Hemisphere people are going to have to have hot chocolate with marshmallows in protest of all this mouth-watering BBQ action. We've a top of 13°C/55°F...

Chris Houghton (7/19/2010)

---

Jim McLeod (7/18/2010)

---

I'm a little shocked that the transaction log is only backed up once per day, but it's probably a data warehouse that loads overnight, and has...

This all depends on each individual situation. Many small updates will be slower than one mass update statement, but for a complex query, most of the performance impact is...

Internally, the object with # get a different name:

CREATE TABLE TempDB.dbo.DBs (i int IDENTITY)

SELECT * INTO #dbs

FROM sys.databases

SELECT * FROM TempDB.INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%dbs%'

These names look like:...

Ah, that makes sense. Unfortunately, you can't (easily), from a technical standpoint - it's very much a management issue. Even if the two developers had different logins, it...

While you can use DDL triggers to capture the ALTER event, I'm curious as to the circumstances that would warrant this. Are you trying to force a particular developer...

Take a look at http://msdn.microsoft.com/en-us/library/ms177425.aspx under the section "Piecemeal Restore Under the Full Recovery Model". There's an example as well.

First, you want to take a tail log...

I agree with (d) and (e). Remember that a backup strategy should also be a restore strategy. If you only take log backups (d), and your database crashes...

It's worth pointing out that unless you have Enterprise Edition, and can rebuild your indexes online, then you will have a period of downtime when each clustered index is unavailable...

I haven't tried your example, but it does sound possible, so I'll take your word that it works.

As you've described it, it does allow a SecurityAdmin to create a new...

sumit.agrawal (7/16/2010)

---

U need to put condiition to build @Collist string.....

Try replacing <SET @Collist = @Col1 + ',' + @Col2> with .........

---------------------------

if @Col1 is null

SET @Collist = @Col2

else if...

Your problem is that you're passing nulls in, and trying to add a null to a varchar string. This can result in one of two things: a null,...

Is the feeling of insecurity good or bad for your career? Is it motivating to try and absorb the entire collective intelligence of the SQL Community? Or is it...

A useful tuning technique may involve converting views to functions, or tables to views, etc.

For example, you might create a second table, and then use a view over...

I've recently been looking at a similar problem - approximately 25 databases all with links into other databases, and we can't upgrade them all to 2008 at once. sp_depends...