Parachute

Given that humans have taken 200.000 years to become as stupid as they are and that computers do things much faster than humans, we (humans) should be afraid, very afraid:-D

😎

I think you have to rephrase this question, online analytical processing/olap is an approach to mda or multi dimensional analytics, which dimensional modelling is an integral...

You are very welcome!

😎

I just improved the code sample to demonstrate that query will use index seek if the proper index is in place.

thbaig (7/28/2015)

---

Hi,

I need to select records in column that start with '% ' -- %space e.g. column A = % mytest

I tried select column name with like operator but it...

Simple...

Brandie Tarvin (7/27/2015)

---

Eirikur Eiriksson (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

SQLRNNR (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.

Thanks for...

Biank (7/27/2015)

---

Hello,

Anyone know if this is a bug that we can't insert getdate() value from SQL 2008 R2 to a smalldate column on a table in SQL 2005 via Linked...

Good work indeed Luis, nicely done!

😎

Although "theoretically" this is right, one cannot endorse the use of @@ROWCOUNT in that way, too many gaps and exceptions.

😎

Could anyone check this one out, feels like I'm missing something

😎

Quick thought, hope you have either the appropriate firewall/security measures in place or that the machine is either not connected or unplugged from the internet, XP is indeed inherently vulnerable...

Brandie Tarvin (7/27/2015)

---

SQLRNNR (7/27/2015)

---

Brandie Tarvin (7/27/2015)

---

Wow. Even on The Thread I am having the learning of the stuff. I've never heard of this until today.

Thanks for bring up the topic,...

Here is the previous query adjusted to the changes, it uses HASHBYTES but it depends on the width of the columns whether it's beneficial or not. The plan has two...

Just turn the compression on, no other changes needed although you might want to check if Commvault is also compressing the files.

😎