There are also links on that page that allow you to download it in a variety of formats. I can't help you with any problems with downloading or viewing.

There is a Paul Randal video, dealing with backup internals - http://technet.microsoft.com/en-us/sqlserver/gg429796.

A nice solution dwain - it would never have crossed my mind to try that.

Two UNPIVOT queries, one filtered for the 'X' and the other for the 'Y' and a UNION between them.

Give it a try and then get back to us if there...

SSIS can be used for this - http://msdn.microsoft.com/en-us/library/ms137870(v=sql.100).aspx.

I had a similair situation here.

I created a test table with roughly 3 million random dates in it and then ran the existing code and revised code against this....

arthurolcot (7/6/2012)

If I had a bit more time, I would look at trying to pivot the source data rather than loads of joins into a much wider table and then...

Out of curiosity, does any of you administer instances without ANY rights on the windows machine?

And, please, anyone tell me how to administer a cluster without permissions on the cluster...

http://sqlserverpedia.com/wiki/Wait_Events_-_Sys.dm_os_wait_stats

If you mean, creating a column that has a name which is a specific date, then yes it is possible by using dynamic sql (formating of the name may be...

The one that kept insulting people and calling them 'Fool'? That has...

balaji_kethe (7/17/2012)

---

CREATE TABLE Test(

ColA [varchar](500) NULL,

ColB [nvarchar](500) NULL,

.

.

ColK [nvarchar](500) NULL,

)

I am getting NULL records...

Please post the definition of the table, then we don't have to guess and can help you faster.

I've attached some code that may do what you want.

It uses xp_cmdshell to write all of the filenames into a table, then uses a cursor to read through these filenames...

For explaining the concepts behind a database in a clear and concise manner you could do worse than the book "The Manga Guide to Databases".