I concur that overall SQL Server is an excellent tool and one that is a large part of how I make my living, and I am glad to know passionate...

James Rochez (5/9/2008)

---

XP_FileExist

The usage is:

EXEC xp_fileexist <filename> [, <file_exists INT> OUTPUT]

If executed without providing an output variable, it will display 3 columns indicating whether the table passed exists, whether it...

Anatol Romanov (5/9/2008)

---

All extended stored procedures mentioned in the article are well known to most of the people working with SQL Server for some years. They have been discussed many...

rnjohnson10 (5/8/2008)

Are you kidding me? If something is hanging up the server, the GUI will take minutes or longer to show you what's happening. Using sp_who2 is generally...

Excellent article and and a very nice analysis of a new feature in 2008. Of course, the feature is much less impressive to people like me already using something...

I partially agree with you. XML is definitely highly over used and sold to do far more than it really can. With that said, it certain does have...

I know I am coming to this article many months after it was published, but we are just now looking at implementing encryption and this has helped me tremendously. ...

There are definite places where functions are of value, but it is important that they be written carefully to avoid replicating work. In one of the examples listed, the...

I think the question comes to down to their job function. The first obvious thing is that you cannot give users too much control in a situation where many...

There is nothing inherently wrong with doing file handling from within a T-SQL script when needed , and it is possible to set the security on the windows system...

There are almost always multiple ways of doing something. They would both be graceless and inelegant but you could use a series of union all statements and you can...

Awesome article.

This is definitely a good starting point for what should be monitored. The majority of this list can be automated relatively easily, which generally makes more sense than requiring...

Congratulations Kathi and Jacob.

The answer depends on which definition you want to use. Going by JEDEC, it is 1024^8 = 2^80, but going by SI you get 1000^8th.