Viewing 15 posts - 61 through 75 (of 389 total)
just a good article. No question.
August 10, 2016 at 8:59 am
drew.allen (6/24/2016)
I think that Luis' solution will perform faster than any looping solution, especially once the square root short circuit is added.Drew
surely the cte is faster, but they do different...
June 24, 2016 at 4:20 pm
Here is something I did some time ago.
Little bit loopdy loop, but returns primenumber list from first million integers in about 12 seconds on my server due to optimised incrementing...
June 24, 2016 at 9:20 am
GilaMonster (6/22/2016)
MadAdmin (6/22/2016)
Cos the plan cache is there, juicy enough to eat, with all the info you need in one crispy query.
His event is for actual execution plans (plans with...
June 22, 2016 at 9:38 am
simon.letts (6/22/2016)
Hi,I want to get the Exec Plans for anything that uses my TBS_SEG_WORK_CON_ORDERS_DATA table.
Is this a problem that you want to solve with Extended events and only...
June 22, 2016 at 9:23 am
Find the queries that are using each index to do a search or scan.
THEN
Look at the code and see if the entire index is being used.
Do this for all queries...
June 22, 2016 at 7:04 am
This returns 3 rows from the base table when doing the except both directions.
;WITH CUSTOMERS_SALE AS
(
SELECT
SSF.CUST_ID
...
June 16, 2016 at 9:00 am
Just wondering.
Why so many [float]?
Design choice?
June 16, 2016 at 7:08 am
What is version of primary, and what is version of secondary?
You will have an error if the primary is 2016 and secondary is 2012.
June 16, 2016 at 6:31 am
I would check the setup logs.
I had an issue but that was with SSRS and had to look throught the logs to find that out.
Might be here somewhere
C:\Program Files\Microsoft SQL...
June 10, 2016 at 9:45 am
Snargables (6/8/2016)
June 10, 2016 at 2:47 am
I got same error and then after fixing got the error of converting from int into tinyint.
Here is a less iterative way that does not include global temp tables and...
June 9, 2016 at 7:46 am
Hi
I have made it work with varchar and nvarchar max, and also XML.
Also, I have compacted the nested if statements so that we have one insert.
Also, I have added a...
June 3, 2016 at 6:34 am
Gareth Swan (6/2/2016)
June 2, 2016 at 10:11 am
Check to see if the tables have the same columns and indexes in prod and dev.
If it is sorting on Prod but not on Dev, then I assume that the...
May 9, 2016 at 5:40 am
Viewing 15 posts - 61 through 75 (of 389 total)