Viewing 15 posts - 1,786 through 1,800 (of 6,036 total)
Jason A. Long (11/30/2015)
The other, less attractive, options are to use either a cursor or while loop.
"Less attractive" is a questionable judgement.
There were several tests here which proved that...
November 30, 2015 at 12:33 am
Well, none of the parsing solutions can be named correct.
This part:
REPLACE(REPLACE(@json,'}',''),'{','')
might work for the given simplified set of data.
But if simply removing "{" and "}" from a JSON string would...
November 29, 2015 at 10:19 pm
Welsh Corgi (11/27/2015)
I am against partitioning in this situation.I have archive procedure that is very complex.
How can I convince my VP that partitioning is not the way to go?
First -...
November 28, 2015 at 6:04 am
Chris-475469 (11/26/2015)
I was about to commission a new SQL instance to host several app databases when I noticed that one set of databases for a particular app has a...
November 26, 2015 at 8:17 pm
OK,
Turns out, Scott does not want to discredit his religious beliefs by publishing results of scientific tests.
So I decided to wrap the discussion with doing my own test using Active-Inactive...
November 26, 2015 at 6:04 pm
Try the query.
Use it as a pattern for actual queries in your stored procedures.
There is a good chance that after seeing the actual performance of ckustering the word "partition" would...
November 26, 2015 at 2:09 am
Welsh Corgi (11/25/2015)
I thought that since I was partition by BeginDate I had to include that in the Clustered Index?
If you think about partitioning by [BeginDate] you should have at...
November 25, 2015 at 8:11 pm
ScottPletcher (11/25/2015)
November 25, 2015 at 4:16 pm
Welsh Corgi (11/25/2015)
Scott,Please see attach Excel file.
Unfortunately I had a hard time interpreting what you were telling me to do.
Thank you for all of your you help.
The stats look not...
November 25, 2015 at 3:58 pm
How many records per one call_id do you typically have in this table?
November 25, 2015 at 3:28 pm
Welsh Corgi (11/25/2015)
CREATE TABLE [dbo].[xactControlPoint](
[xactControlPointID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[xactControlPointTypeID] [int] NOT NULL,
[call_id] [int] NOT NULL,
[contr_id] [int] NULL,
[xactTransactionIDValue] [varchar](50) NULL,
[beginDate] [datetime]...
November 25, 2015 at 3:22 pm
Declare @Table table
Populate it using "query"
Add rows to @Table using
select query.............
join some query ................
join @Table on some query
Repeat.
November 25, 2015 at 1:55 pm
MMartin1 (11/25/2015)
As mentioned in the blog, in a DW with over 100 Million rows , most of the queries will end up performing scans
I dont know what qualifies as "most...
November 25, 2015 at 1:53 pm
Welsh Corgi (11/24/2015)
ScottPletcher (11/24/2015)
When I do partition, I align indexes because I want to...
November 24, 2015 at 10:35 pm
Viewing 15 posts - 1,786 through 1,800 (of 6,036 total)