Viewing 15 posts - 271 through 285 (of 562 total)
Jeff Moden (2/19/2016)
That's why I nip all of that in the bud when we design something new or need to fix something old.
Started working with computers in 1974. He that...
February 22, 2016 at 6:17 am
Rebuild the table from scratch.
Timing with No 3.
'No 3 create index IX_forced ON TestTable (EndDate,StartDate) NO CLUSTER'
2016
Cache 20.04 Mb
time 0.4066 secs
Showplan (Execution plan is added a a...
February 22, 2016 at 5:24 am
Here is the 'showplan', BUT, see below:
StmtText
|--Compute Scalar(DEFINE:([Expr1004]=CASE WHEN [Expr1013]=(0) THEN NULL ELSE [Expr1014] END))
|--Stream Aggregate(DEFINE:([Expr1013]=COUNT_BIG([Expr1005]), [Expr1014]=SUM([Expr1005])))
...
February 22, 2016 at 3:40 am
Jeff Moden (2/18/2016)
ben.brugman (2/18/2016)
This is a very sensible remark, but why not use 9000-01-01. This contains more 'zero's' so to me it is more logical :-).
Only because SQL Server implicitly...
February 19, 2016 at 9:38 am
Created and used indexes.
After the test with an index the index is removed.
...
February 19, 2016 at 7:51 am
ChrisM@Work (2/18/2016)
How about starting a new thread with some sample data thrown in?
See:
A new Thread with begin and end dates
Jeff Moden (2/18/2016)
Just to be sure, let's say we have a...
February 18, 2016 at 9:23 am
Jeff Moden (2/16/2016)
ben.brugman (2/16/2016)
Still working on situations where we want to select a specific period and subscribers at that moment.Please see the following article for that...
Did read your article. Thanks.
The...
February 18, 2016 at 1:44 am
Changing the collation is a huge effort in my opinion.So if it is not needed, don't do it.
If there is not 'connection' with other databases, there is no need.
There is...
February 17, 2016 at 4:43 pm
Hello Jeff,
Thanks for your scripts.
Did have a gap and island method which was a tad bit slower, so I am happy with the script.
But I did make some alterations.
during testing...
February 16, 2016 at 9:48 am
WhiteLotus (2/14/2016)
Any steps that I miss out ? or can I use Backup – Restore ?
No you can't.
Within the management studio there is a possibility to copy a database.
But I...
February 15, 2016 at 6:06 am
Jeff Moden (2/12/2016)
[font="Arial Black"]EDIT EDIT: Also just noticed that Ben was also right there (excluding exact matches).[/font] That's what I get for not reading further down. :blush:
Yeah, that's...
February 15, 2016 at 6:00 am
For your last example:
select * from #t as a where
A.t > @pointfrom AND @pointto > A.f
Ben
February 12, 2016 at 6:36 am
--
-- Create a table with content. (Containing periods of hours, days, months and 24 hour periods)
--
DECLARE @test_a table(a_start datetime
...
February 12, 2016 at 6:14 am
Although with my collation change, I did it within the database, probably the next time I would test if copying all the data to a database with a 'correct' collation...
February 12, 2016 at 1:41 am
Viewing 15 posts - 271 through 285 (of 562 total)