If each partition holds 4 hours worth you will need 48 partitions (+1) to cover the eight days, maybe a days worth could be fine? All depends on the environment,...

First thing that comes to mind is to partition the tables, have you looked into that?

😎

sqldriver (7/5/2014)

---

Hi Eirikur,

You were half right, but it was right enough to get things working. The versions and paths both matched, but for some reason SSMS would run directly from...

I've come across this problem few times in the recent past and found that Implicit conversion from CHAR/VARCHAR to NCHAR/NVARCHAR and vice versa, will cause Index Scans which can lead...

Quick question, how are you invoking the SSMS, by clicking a menu item or short-cut?

If so, right click on the menu item/short-cut, select Properties and Open File Location. Then right...

Quick question, can you provide some sample data?

😎

Only one thing, if the date value of the null v entry is either the earliest or the latest within the partition, it will not be ignored. Setting it to...

First thought would be looking at any looping (i.e. ForEach) iteration's configuration. Next would be a file system problem where a parent folder is mounted in a child folder, could...

Use the same method, just null the date in the subquery

😎

USE tempdb;

GO

declare @t table (v1 int , v int, v2 datetime)

insert into @t values(4,10, '2014-01-01 10:00:00')

insert into @t values(5, 20,'2014-01-01...

Quick question, what is the expected output?

You could use MAX with the right window specification

😎

USE tempdb;

GO

declare @t table (v1 int , v int, v2 datetime)

insert into @t values(4,10, '2014-01-01 10:00:00')

insert...

Quick pointer, the query is only a character string in the code and it never gets executed. Change the code to include the query not using a string.

😎

Quick question, what is your SQL Server version?

😎

Jeff Moden (6/30/2014)

---

... sooooo, throw the packages out,

you...

WayneS (7/1/2014)

---

SQLRNNR (7/1/2014)

---

Jeff Moden (6/30/2014)

---

... sooooo, throw the...

DECODE can be replaced by a case statement as it is...