Grant Fritchey (1/30/2008)

---

Oh yeah, do that. The Static Code Analysis tool is a great way to review TSQL. It replaces a lot of the functionality that they dropped from the...

If you haven't done so already be sure to download and install Power Tools for the Database Professional. It adds functionality such as additional data generators.

gdmilner (1/25/2008)

---

Hi. You can think of GETDATE() as a system function that returns a (scalar) value that you assign to your variable. In this case, either SET or SELECT will...

I presume you mean that the code you provided works on other servers but not...

JohnG (1/23/2008)

---

No, SQL Server doesn't conform to the generally accepted/ANSI standard that you must SELECT from "something" (table or view).

So you can just SELECT a constant. E.g., SELECT 'foo';...

Loner (1/18/2008)

---

I had a multiple interviews and the feedback of the interview was good. However at least three companies said they were still thinking about if they need the...

Brandie Tarvin (1/21/2008)

---

... the contracting rep showed up late to the interview, then got mad at the HR lady because she was in meetings (apparently she only had a very...

jschroeder (1/18/2008)

---

As a result of these posts, I have already switched from Access to SSMS to create queries. It doesn't crash when I use aliases, allows me to indent, doesn't...

GSquared (1/18/2008)

---

They had Access as a front end for some internal use of the database. It's forms and reports are a very rapid development platform, on top of an...

Matt Miller (1/18/2008)[/Donald -

for what it's worth - there IS a graphical editor in SSMS. Once you open a new query window (the text one), just right-click...

"...I guess another option is to continue being a DBA and start having some fun... "

Woohoo, go, Tony! Instead of the Galloping Gourmet you'll be the Drivin' DBA with...

"Basically agree with you DonaldW.

One experience I had, though, makes me put at least this warning on that idea.

I had a query that joined a table, through a many-to-many table,...

And don't forget the non-working part of your life. You may find that you develop a...

I agree. However Access has one good feature for people...

"...then you have a whole host of new problems..."

Yeah, you are hosting a hacker's new attack site. Arrrrggggghhhhh!