We run our SQL servers on VMWare and have been very happy with the performance. BUT, we are a small organization with a lightly loaded primary SQL server with...

skcadavre (12/16/2010)

---

Backups used to be made regularly, but due to disk space it was turned off (not by me).

In the end, the tape disk was there, so I was able...

I also got it right but don't like the available answers.

If MS and T-SQL experts emphasize that the only reliable way to return a result set in a specified...

The only reason I got this right is that there was a QoD some weeks back that had a default data length as part of the question. I got...

Thanks Jeff, for your customary focused, useful style and content!

<math_complaint>

Your article points out a secondary annoyance here in SQL: the ROUND() function returns a value of the same type as...

*Puts hand up from back of room*

CREATE TABLE #PartsOfSpeech

(

WordType VARCHAR(30),

Definition VARCHAR(200),

Example VARCHAR(1000),

Notes VARCHAR(1000)

);

GO

INSERT INTO #PartsOfSpeech

(WordType, Definition, Example, Notes)

VALUES

(

'Gerund',

'A verb used as a noun.',

'Replying to SQL Server Central articles...

Ask yourself some questions before you get to the SQL. You have a table you've called BoatBooking, so presumably we are booking (making reservations) for a boat by someone...

GSquared (11/15/2010)

---

Jeff Moden (11/12/2010)

---

sqldba_icon (11/12/2010)

---

Just wanted to throw out a question to developers on what method do they use to loop around different objects.I typically use cursors, was wondering...

Hugo Kornelis (11/18/2010)

---

Good question; many people would expect this to work. (As I did, the first time I ran into this. And the second, third, ... - I answered correctly...

Amy, I flagged your post b/c I'd like to hear an answer, too. It's not a huge priority for me, b/c although we have AD setup here, our primary...

I don't know if this fits your business application, but what if a bank holds the loan on a car? Do you list 2 owners for the car, the...

Now [font="Arial Black"]THAT[/font] would make an interesting discrimination court case. 😉 I can see the judge now... "Didn't you know you weren't supposed to walk into the den of...

that was what i would expect and adds to my position that i do not understand why sql server strips out the trailing spaces when it tries to index. It...

Well, you need sysadmin role membership to establish a DAC:

http://msdn.microsoft.com/en-us/library/ms189595.aspx

Why do you ask?

Rich

Hey Jim, maybe this will help (maybe not....:-D ):

CREATE TABLE TrailingSpace

(id INT IDENTITY (1,1),

myText VARCHAR(6)

);

GO

INSERT INTO TrailingSpace (myText) VALUES ('abc');--no space

INSERT INTO TrailingSpace (myText) VALUES ('abc ');--1 space

INSERT INTO...