Interesting, thanks.

If the expression is a string literal, it must resolve to a datetime. - https://msdn.microsoft.com/en-us/library/ms186819.aspx

Consider that SQL Server retains the 900-byte limit for the maximum total size of all index key columns.

https://technet.microsoft.com/en-us/library/ms191241(v=sql.105).aspx

prem.m38 (2/17/2016)

---

Hi Igor,

Thanks for your script, In my environment we have partitioned the tables with business_date column so we need to keep yesterday data uncompressed and all previous date should...

Hi,

I uploaded a script that I used to use for compressing databases. I had a similar issue like yours.

I run your query on sql server 2014 and it works.

What is the error message you have when you run it on sql 2012 ?

It should be something like these queries:

select count(distinct Customer_id) [Number of customers]

from [dbo].[ordertable] t

where convert(date,Order_Date) between '2016-01-01 00:00:00.000' and '2016-01-31 23:59:59.997';

;with cte1 as

(

select Customer_id, count(*) [Count]

from [dbo].[ordertable] t

where convert(date,Order_Date) between...

spaghettidba (2/16/2016)

---

Your Patient table is horribly overindexed. That's what you get when you accept all the recommendations from the database tuning advisor.

I recommend that you look at the utilization of...

Try to replace the cartesian products (cross joins) with inner joins in your querys. It could make your query faster.

See this https://technet.microsoft.com/en-us/library/ms191472(v=sql.105).aspx

Was this inspired from QotD "Converting hex values" on Feb 9 ?

"repeating is the mother of knowledge"

Thanks

Sergiy (2/9/2016)

---

Igor Micev (2/9/2016)

---

Not so different from my approach. I make a column drop and rename, and you make a table drop and rename. The prepared dependencies goes for creation...

Sergiy (2/9/2016)

---

With my approach?

No.

Read it again:

1. Create a new table with desired table design.

2. Start populating the new table with portions of...

Sergiy (2/9/2016)

---

Yeah, right.

I once disabled an index which was a duplicate of another one and was only taking space without any benefit (as I...

Sergiy (2/9/2016)

---

Igor Micev (2/9/2016)

---

I don't say Sergiy approach is not going to work, but it's more risky. Simply you can do it without dropping the table.

-- Steps:

-- 1. Script the...

I don't say Sergiy approach is not going to work, but it's more risky. Simply you can do it without dropping the table.

-- Steps:

-- 1. Script the Drop and Create...

You cannot. You should use IF statement to control the flow.

The CASE statement returns a result expression based on the input, so you couldn't make transactional operations in the...