Viewing 15 posts - 781 through 795 (of 6,036 total)
Perry Whittle - Wednesday, July 12, 2017 4:27 AMDon't!
Just use my script above to find growing indexes or heaps
And then what?
OK,...
_____________
Code for TallyGenerator
July 12, 2017 at 6:11 am
Optimal definition of a clustered index for a table depends on the table definition and the typical workload which the table is involved in.
Creating a clustered index on a busy...
_____________
Code for TallyGenerator
July 11, 2017 at 9:54 pm
Create a clustered index.
Do you have a copy of the database restored in a test environment?
_____________
Code for TallyGenerator
July 11, 2017 at 1:51 am
You forgot to mention dreadful performance of DATETIME2.
Any operation from a standard set would take times longer if executed against DATETIME2 comparing to DATETIME.
All the PRO's you listed are pretty...
_____________
Code for TallyGenerator
July 10, 2017 at 7:34 pm
Find a script which indicates the size of every index in the database.
Run it repeatedly and see which index(es) grow the most.
If it does not give you any clear indication...
_____________
Code for TallyGenerator
July 10, 2017 at 12:35 am
UNCOMPRESS is an undocumented internal function that unpacks a binary to a string format, does the same as CONVERT with the format parameter set to 0.
And I'm sure figuring...
_____________
Code for TallyGenerator
July 7, 2017 at 6:35 am
_____________
Code for TallyGenerator
July 6, 2017 at 7:11 pm
OK,
try
SELECT *
INTO #Table
FROM View
WHERE 1=0
_____________
Code for TallyGenerator
July 5, 2017 at 9:55 am
July 5, 2017 at 9:10 am
There might be more factors than just a number of bottles which could define a price. _____________
Not to mention - price must not be defined "per bottle", but "per pack".
Code for TallyGenerator
July 5, 2017 at 5:42 am
Try insert without ORDER BY
_____________
Code for TallyGenerator
July 5, 2017 at 5:28 am
_____________
Code for TallyGenerator
July 5, 2017 at 4:13 am
Hi Des,
The approach you used was very popular amongst front-end developers, but it was condemned quite some time ago, when I was still young and hopeful.
It's a...
_____________
Code for TallyGenerator
July 5, 2017 at 2:50 am
_____________
Code for TallyGenerator
July 5, 2017 at 12:59 am
Goosfraba
_____________
Code for TallyGenerator
July 4, 2017 at 5:38 pm
Viewing 15 posts - 781 through 795 (of 6,036 total)