Here is where I replied to your cross-post.

http://www.sqlservercentral.com/Forums/FindPost1724193.aspx

So, the question is how to keep the overall design straight in your head while you're developing?

I'd suggest reading Ralph Kimball's book "The Data Warehouse Toolkit". If you haven't...

I've found that some advice is better received when delivered one-on-one rather than in front of a group. Otherwise, the ignorance of the crowd or the cult personality of the...

Steve Jones - SSC Editor (9/29/2015)

---

Eric M Russell (9/29/2015)

---

To be a true Data Scientist, you probably need a solid academic background in data analysis as well as deep knowledge of...

To be a true Data Scientist, you probably need a solid academic background in data analysis as well as deep knowledge of whatever domain you're working in. I'd also expect...

Even if a user has execute permission on a stored procedure, I'm thinking that if the user's account can't at least see the meta-data signature for the procedure name and...

For SQL Server 2000, you probably...

Is this topic a duplicate of the one posted yesterday under SQL Server 7,2000 Administration?

Continuous slowness from last 2 week

http://www.sqlservercentral.com/Forums/Topic1723583-5-1.aspx#bm1723614

Confirm if it's SQL Server 2000 or 2008 you have this...

rchantler (9/29/2015)

---

Thanks Kristen,

Yes, not precisely the same but in my mind (perhaps where the problem lies) functionally the same as the hid field is always unique, even if not declared...

rchantler (9/28/2015)

---

Thanks Eric,

Thanks for the script, I'll see what the results it gives.

The execution plans are totally different. That's the point really. Why should the execution plans be...

For each temporary tables currently allocated, the following script will return the table name, index type(s) (heap, clustered, non-clustered), reserved mb, and row counts. Using this, confirm the allocation of...

EasyBoy (9/28/2015)

---

Hello,

...

Edit: Usually there is no error message encountered by staff. It is just relatively slow, to the point where Application just freezes. They claim that switching tabs takes about...

If this is all about how to sort alpha-numeric columns of varying lengths in a specific way, then I sometimes will order by an expression that does something like padding...

paul.knibbs (9/28/2015)

---

Eric M Russell (9/28/2015)

For example, if you have a VarChar column that should only contain values that are covertable to a specific data type (ie: Int or Date), then...

I tend to avoid both scalar and table valued functions, because it can be a bottleneck when used within a SELECT statement or tight loop (not that I code loops...