Although SQL Server isn't supported on an NAS I managed several database servers that used NetAPP for a storage device. Stability was always an issue. I saw...

Gregg Murray (5/7/2009)

---

I disagree with most of this article suggests:

1) Entire tablenames as alias make the code harder to read and understand. There's nothing wrong with...

I read this thread in total amazement. It has become quite obvious that there are not only a variety of styles of code development but developers have become quite...

My approach is quite simple. Often times I am passing in a date range into a sproc for selection criteria. What I do is the following

set @SubmitDateFrom ...

Just imagine SQL Server running on UNIX wow!

Kurt

Matt Whitfield (12/24/2008)

---

@jacroberts -

I didn't get any faster results out of the firehose than I did out of the select-only method. I ran it a few times, they came out...

It wasn't difficult to find the ???? in the script and was able to get it to run. However due to the nature of the way some of my...

Don't you love happy endings???

Kurt

How long did you wait? Mine has been recovering for quite some time now (5-6 hrs)

Kurt

"Then you can run some command to rebuild the log ...." and that is? I'm having the same issue and I was able to rename the log but...

Greetings... I know this was about 4 years ago. It would have been helpful to all to identify the solution you ultimately used to resolve your problem.

:doze:

Greetings all... I had an issue that came up some time ago in my SS 2000 box. I was able to find an extended function that allowed me to...

Matt Miller (3/4/2008)

---

If my italian isn't entirely shot - it's stating that the path isn't correct. Meaning - it doesn't understand what "Z:" is under the credentials executing the...

I am in the process of migrating a 68gb database from 2000 to 2005. I plan on using the "copy database" method and have produced the SSIS package.

Here are...

I have been spending a lot of time rewriting older queries that utilize sub-selects in where clauses, much like the one that appears in this thread. I have seen...