OK, maybe someone said this already. I also had the issue of the data file that won't shrink. Upon seeing this post I decided to run it again on a...

Have you tried to see what books online says about DBCC SHRINKFILE?

Hi Steve, good article you have here. Microsoft is making it so diffcult for a person to install SQL Server from 2005 upwards. I don't really know the older versions...

stevensonk (8/13/2008)

---

I have created many queries using Excel as my tool. Instead of stored procedures I use Views because they allow parameters. create a view in SQL and in...

Steve, I fully agree with you and I feel bad because I am no longer so involved in the SQL community anymore. My work keeps me so busy and I...

Steve, in South Africa we have a saying and it actually sounds better in Afrikaans (dialect of Dutch). We say you hit the nail on its head. Well said there....

I fully agree with Nakul about the planning and distribution of bugs among developers. I unfortunately do not have the luxury of having other developers with me other than my...

I would say both. They knew what was wanted but gave what they thought was best. I hate it when I want to buy something and people want to tell...

When my client upgraded from SQL 2000 to 2005 they said now the server and database is my baby. I had a lot of learning to do and very quickly....

Why, I am a great fan of sci fi and particularly enjoyed star wars. I also liked Star Trek and it was always fun to see Data (robot that looks...

I had many hobbies but I soon grew tired of them. One hobby though that I would like to take up is woodcarving. It was a passion of my mother's...

Jeff Moden (5/27/2010)

---

It's a funny thing. I do SQL for a hobby, love it, and do it for a job. I also have several other hobbies but, for...

I have a small 12 GB database to look after plus I am not a DBA since I am actually one of the developers that developed this database and I...

Mr.Gonzalez,

I apologize for the "File" part. I never saw the part where you said at the top we must add System .IO.

Dear Mr Gonzalez,

Your article lack somewhat in explanation. You keep refering to "your example" and "if we used your example" but then you use variables that was not created in...