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.

😎

The problem here aren't the Window functions as such but the way they are being used. The query requires the set to be sorted 4 times and each sort likely...

tct_sql_admin (7/26/2015)

---

I am writing some scripts to calculate mean (avg) stdevs count and percentile_cont for some data

I am partitioning over multiple columns e.g. partition by year,month, day order by value

My...

rajemessage 14195 (7/26/2015)

---

hi,

I want to log <=10 severity level error, for all database and for single stored proc.

please tel me how it can be done.

(with out using...

joelgrizly009 (7/25/2015)

---

I cannot open Microsoft Access files. It gives me a message of: Please wait while Windows configures Microsoft Access XP Professional. This flashes across in a dialoge box, the...

sqlfriends (7/24/2015)

---

Anyone installs multiple instances on a SQL server either virtual or physical?

All my company's SQL server currently only have single default instance.

I know we can install named instance besides...

Infrastructure

Octet