herladygeekedness (2/14/2012)

---

I mean zip as lowest. The smallest granularity. The largest population.

States have many cities, cities can have one or many zip codes but a zip...

herladygeekedness (2/14/2012)

---

Yes, any time a piece of data could be the child of more than one parent, you have to have an indicator of which parent it goes to.

Ideally, getting...

I dug into login triggers a little bit (since I don't write those every day) to confirm a few things.

What you want to do is get the SPID from the...

The spreadsheet will need to contain the parent object for each row. Cities will have to have states with them, and so on. No way around that.

Of course,...

The problem looks like it's the Execute As.

The login trigger proc is running as AnonLogin. Thus ANY login calling that proc qualifies as being a SPID that should be...

Execution plans can be in text format or XML format. Behind the scenes, there's going to be a binary format, but I don't think there's a way (or reason)...

I'm not used to city, state, Zip tables being something that has to be imported repeatedly. That data doesn't change frequently.

But if I had to, I'd set up the...

Some SQL tools I've used:

DB Dev:

SQL Prompt

SQL Search

SQL Compare

SQL Data Compare

SQL Data Generator

SQL Dependency Tracker

SQL Doc

ApexSQL Edit

ApexSQL Version

ApexSQL Refactor

ApexSQL Complete

Team Foundation Server

Visual Source Safe

DB Admin:

Confio Ignite

SQL Monitor

SQL Backup Pro

SQL Multi...

The second one won't clear tempdb. You can only remove an empty file. If tempdb has empty files, you could do this to remove them, but you won't...

TheSQLGuru (2/13/2012)

---

>>Joe, there's no question you know the trade

But that "trade" is GENERIC, STANDARDs-based SQL. He does NOT know "SQL Server" and over the years has routinely given BAD...

Is there no clustered index on this table? How about a primary key?

Heaps often behave "strangely" compared to tables with clustered indexes. Lack of a primary key can...

kschwid (2/13/2012)

---

I don't think it will hurt for you to have nolock on.

Any stored procedures that I write I add that in, regardless of how long something takes to...

On the original question, Select takes a "shared lock", meaning multiple Selects can run on the same rows at the same time and won't block each other. No need...

SQL Kiwi (2/13/2012)

---

Replying to the article: the horrible *= and =* syntax is finally dead in SQL Server 2012 (no 80 compatibility). Semicolons are generally a good thing, but...

cphite (2/13/2012)

---

We have a database that's had a trailing space at the end of it's name since before I started with the company. So far they've resisted letting me...