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

Congratulations again Gail, good job indeed!

😎

Alvin Ramard (7/23/2015)

---

Steve Jones - SSC Editor (7/23/2015)

---

Alvin Ramard (7/22/2015)

---

Brandie Tarvin (7/22/2015)

---

Gotta love it when someone schedules a software change/update at month end. Because "there's no impact to the business"...