Phil Factor (5/9/2008)

---

A while back, I decided to try writing a blog posting every week. It wasn't for a SQL Server site, but for an unrelated interest. Heaven only knows...

declare @yearnum int

set @yearnum=2008

set @yearnum=@yearnum-1900

SELECT CONVERT(varchar, Event.EventDate, 110) AS Date, Player.PlayerFName AS Players, Scard.Ranking AS Ranking

FROM Scard INNER JOIN

Event ON Scard.EventID = Event.EventID INNER JOIN

Player ON Scard.PlayerID = Player.PlayerID

WHERE

Event.eventdate...

Are you by chance running SQL Server Express Edition? If so you may need to download SSMSEE (SQL Server Management Suite for Express Edition) separately.

You can find that here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Note...

Ashley Fawcett-Jones (5/9/2008)

---

If the server on which an instance of SQL Server resides is multi-homed, would you see entries for each i.p. address and port it is listening on to...

Stop - that would be a nightmare. And...

bitbucket (5/9/2008)

---

I can not get the results in one row as you have shown in a simplified manner.

From BOL:

The result sets combined using UNION must all have the same structure....

kevin mann (5/9/2008)

---

I don't know... ask the authors of Access. I cannot control which identity is...

jthorpe (5/9/2008)

---

Does anybody know what the difference in performance is when doing DELETE or INSERT on a table when having / not having a primary key and clustered index? Especially...

Interestingly enough - it's kind of a "heretical" version of 6NF, where you essentially end up with many tables each essentially holding a key and a data column. Heretical...

dfalso (5/9/2008)

---

Jeff Moden (5/6/2008)No... no Reporting Services or Excel required. Take a peek in Books Online for "cross-tab reports" in SQL Server 2000 or follow the following URL...

http://msdn.microsoft.com/en-us/library/aa172756(sql.80).aspx

They're very...

jburkman (5/9/2008)

---

Funny timing, this. I was tempted this week to write a bit explaining the COLUMNS-UPDATED because BOL bites on that topic. But it filtered down to not...

Darryl864 (5/9/2008)

---

I have now resolved the issue by taking the databases off-line and forcing the log file to shrink to 2GB. I found that the log file was set to...

jpchiu (4/30/2008)

---

stop your sqlserver

delete the tempdb.mdf under your program files\Microsoft SQL Server\MSSQL.x\MSSQL\data folder

restart your sqlserver

this will recreate the tempdb back to the initial size by default (8MB) if you didn't...

What is usually done in these cases is to create a temporary table mirroring your existing table, with the correct identity seed and increment, then copy the data over, and...

From what you're describing - I'd actually steer clear of the script component, and look into the conditional split task instead. In other words - split your data on...