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

If any of the application or user accounts have sysadmin membership, then that complicates the issue. However, another option to mitigate that is to alter login status to disabled for...

Ideally you will never have invalid column values inserted in the first place, because once the bad data is in the table, then all the downstream applications have to tiptoe...

Did you look into using TRY_PARSE() ?

Rather than telling you True or False if value is "numeric", it will tell you if the value will cast as a specific data...