You're trying to add a string to an INT field in the first query, which isn't possible. Your attempted fix is trying to convert the string to a number, again,...

Except of course for the hard way, create a new table with the new structure, drop all the constraints on the old table, copy the data over, put the constraints...

Oh, I made the mistake of following up on his thread... encouraging bad behavior. "Bad, Grant, Bad! Down! Stay!"

It sounds like it was building out execution plans for all the recursions (guess). Instead of trying to get the execution plan by running the query in SSMS, try querying...

As long as you don't use the INIT clause, you can simply add differentials to the same backup file. That's not how I prefer to do it. I like the...

And fill factor is applicable when creating or rebuilding an index. Once an index is operation or it gets reorganized, fill factor is no longer taken into account.

Two instances on a machine do have two different ports. They can be dynamically assigned. You say you have TCPIP enabled. Do you have the SQL Server Browser service running?...

john.arnott (7/28/2009)

---

Just be careful of starting an internecine battle. There are more of we developers...

NULL values are not your friend when it comes to indexes. You will get a scan. Even forcing the use of the index through the hint will result in a...

Luke L (7/28/2009)

---

And of course a ppt preso won't quite cut it. Perhaps use Grant...

Yep. Once a month. We'd love...

I just validated it, you can get the start time for a statement within a batch by querying sys.dm_exec_sessions. I posted a blog entry on it here[/url].

Jeff Moden (7/28/2009)

---

Grant Fritchey (7/28/2009)

---

Jeff Moden (7/27/2009)

---

Grant Fritchey (7/27/2009)

---

Man, I'm clearly not doing things correctly. I've had to present twice a year for the last three years. I have the...

There is no process for creating system catalog views. They are part of the normal running of the system and will be there after a successful install.

Are you sure...

there is just no way to be sure. You have to know all the processes that access the system inside & out. For example, even if you monitor the system...