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

sree25 (7/24/2015)

---

I have a column name DateofRecord and it is nvarchar type..all the values in this column are like this

"04/24/2013'

"05/01/2014"...etc...my requirement is to convert this column into Datetime..any suggestions?

I tried...

Clarity

That by itself raises "some questions":hehe:

😎

Quick thought, you can either do a copy/rename snd a delete with a file system task or a rename with a scipt task an file system objecr.

😎

dichotomy

Just a thought,but don't you love your job when:

a) you observe your systems for a while, then make one small change that improves performance significantly and massively reduces the load...