External Article

The Data Center that Exploded

  • Article

A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!


10,375 reads

Technical Article

Storing the output of a FOR XML EXPLICIT in a table?

  • Topic

Hi all,I am trying to store the output of a Select statement with a FOR XML EXPLICIT back into the dbase. Is there any way of doing this? Here is a simplistic view of the SQL on my attempt. Thanks CREATE TABLE #Members (UserNo int NOT NULL PRIMARY KEY, Phone varchar(50) NOT NULL, Email varchar(50) […]


43 reads

Technical Article

??? SQL Server 2000 leap year date comparision problem ????

  • Topic

Hi,A greenhorn questionTry below: create table t1( d1 datetime, d2 datetime)insert into t1 values('20040101 00:00:00.000','20040131 23:59:00.000') insert into t1 values('20040201 00:00:00.000','20040229 23:59:00.000')select * from t1 Result:2004-01-01 00:00:00.000                                2004-01-31 23:59:00.000 2004-02-01 00:00:00.000                                2004-02-29 23:59:00.000THEN TRY:select * from t1 where d2 <= '20040229' Result: 2004-01-01 00:00:00.000                                2004-01-31 23:59:00.000If you try :select * from t1 where convert(datetime,d2,101) <= convert(datetime,'20040229',101)it will […]



Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs


Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers