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...

Unless you change the hardware, a database server will always run at the same speed. However, individual process typically sprint, stop and wait, sprint, stop and wait, etc. It stops...

I'm not a fan of Test Driven Development, as John is. Usually this is because I'm not always 100% sure of the results I want or have been given. I've...

kim / data detection group (9/17/2015)

---

Of course, SQL Server could certainly benefit by implementing the Package concept that Oracle provides.

You can bundle all your related procedures and functions into a...