Viewing 15 posts - 256 through 270 (of 557 total)
Luis Cazares (3/25/2016)
In my opinion, you would be better fixing the process that creates the string. Something as simple as changing the delimiter would solve all the headaches.
Probably most CSV's...
March 25, 2016 at 3:16 pm
Alan.B (3/25/2016)
Are you really on SQL Server 2008? If you were using SQL 2012 this article would get you 90% there:http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/%5B/url%5D
Thanks for the link. I have to process this,...
March 25, 2016 at 3:09 pm
mehta.saurabhj (3/2/2013)
select * from emp where (rowid,1) in (select rowid, mod(rownum,2) from emp);
But if I do the foll code for odd...
March 25, 2016 at 2:41 am
According to Knuth's definition, a B-tree of order m is a tree which satisfies the following properties:
1. Every node has at most m children.
2. Every non-leaf node (except root) has...
February 29, 2016 at 10:05 am
Hugo Kornelis (2/28/2016)
February 29, 2016 at 9:32 am
Found a solution with an indexed view.
Both selections on a recent period and on a period in the past perform fast.
The indexed view:
CREATE VIEW dbo.Vtesttable_recent
WITH SCHEMABINDING AS
SELECT
...
February 26, 2016 at 8:22 am
ChrisM@Work (2/23/2016)
Just to clarify, Ben - it's this system you are attempting to tune:
No, not limited to this system. More to get some good grip range queries. (With variations.)
February 23, 2016 at 9:28 am
ChrisM@home (2/22/2016)
Hi BenThe model system you have posted - does this model a production system or a system in development?
Assuming it's in development:
The model (from another thread) is to learn...
February 23, 2016 at 8:25 am
We have a number of 'models':
Legacy: Build in house the operating system and the DBMS, running since 1973.
SQL-server 1: In house designed/build database. (From the second part of the 90ties)
SQL-server...
February 23, 2016 at 7:24 am
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
Viewing 15 posts - 256 through 270 (of 557 total)