Kit G (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

Jeff Moden (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the...

You're going to have to convert the column to DateTime in the Where clause.

That'll make the query work as expected. It'll be SLOW if the table has any serious...

Jeff Moden (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is...

jcrawf02 (11/2/2010)

---

Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:

http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html

It's also a good blog by the CEO of Beth Israel...

How are they trying to get it? Is there an application? A web page? Do they just query the data through SQL Management Studio?

This whole discussion reminds me of the good old days when there was no such thing as writing and people had to rely on their ability to memorize vast amounts...

I think it would be quite useful on 24x7 systems. Anything else, you probably have downtime that could be used to rebuild an index if you find it really...

You're welcome.

I have to ask: Why do you need a staging table and a final table?

Why not do like I did, and just dump into a table with an XML column?

If...

WayneS (11/1/2010)

---

But... you could have a different problem.

If your job is scheduled to run, say, every 15 minutes. When it runs @ 1:45 (the first time), it gets set to...

You're missing the database name in that. Needs to be between the server name and the schema name ("dbo").

Well, if you can go in and answer how "P equals NP" in complexity issues, then you can expect to pass a senior level interview.

Unless I'm misreading the log, it looks like it was deliberately shut down.

I'd question all the unsafe assemblies being loaded right before that.

select accountnumber,

(select sum(in + out)

from daybook

where accountnumber = accounts.accountnumber)

from accounts;

You can wrap the inline query in a Coalesce/IsNull function if you...

USE [DBA]

GO

/****** Object: Table [dbo].[DDLLog] Script Date: 10/29/2010 13:00:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DDLLog](

[ID] [int] IDENTITY(1,1) NOT NULL,

[LogDate] [datetime] NOT NULL DEFAULT (getdate()),

[LogEntry] [xml]...