Viewing 15 posts - 1 through 15 (of 24 total)
I agree to the article beside the part about the clustering key and Fillfactor. The author argues, that he sets the fillfactor to 90 to prevent page splits. This would...
December 23, 2018 at 10:37 am
If you are using Total Commander, you can press Ctrl-PageDown to enter the archive (similar to switching to a folder) and use the usual Copy-routine to extract the files you...
April 6, 2016 at 1:08 am
Two questions:
- No. 3: "You will get this error as the wizard tries to validate the link connection to the monitor server, but we still need to configure a few...
April 5, 2016 at 6:21 am
"What is the best time of day?" I asked the audience…"6:30 hands down."
Where / what is the point of this joke? I don't get it...
February 1, 2016 at 1:10 am
another point: the select @var = xxx from @tbl with multiple lines works, but is - as far I know - not official supported (= bad hack), so it could...
January 19, 2016 at 12:52 am
I doubt, that your real solution (specifying an explicit collation string at each char field) is really a real solution, because it is very error prone - you have to...
January 14, 2016 at 1:23 am
Regarding extra money vs. free time for extra hours:
I think it depends on many factors. I by myself have to work not many extra hours. On the other hand, I...
December 18, 2015 at 4:40 am
Just steer clear of multi-statement table valued functions, and everything will be OK.
Maybe your devs want to replace RedGateMonitor.[utils].[SplitString] with something as at http://www.sqlservercentral.com/articles/Tally+Table/72993/ :hehe:
November 11, 2015 at 4:03 am
I miss a link to tip #1 and #2 (or a parent page with all SQL Prompt hints linked)
October 29, 2015 at 3:14 am
Good:
- hints about the smallest datatypes
- clustering the table not by the PK but by the ususal query columns (one of the most common mistakes)
Bad:
- no normalization - make...
October 29, 2015 at 2:39 am
Why do you not use a procedure call to dummy-procedure that calls a CLR-procedure for your heavy-calcualtion-stuff?
In this case you would only need to replace the assembly in MS SQL...
October 16, 2015 at 2:38 am
Regarding the truncation prevention: you can create a single table (empty) table with a handful columns (one for each data type used as PK) and create FK's from this table...
October 7, 2015 at 3:22 am
@Peter.row:
Of course it would use high CPU if you use a complicated pattern against a big data set.
And if you have no covering index (where the column is...
September 29, 2015 at 4:17 am
I think because it would need to compare both - the Checksum and the email if you would add both to an index / where condition, even if the checksum...
September 24, 2015 at 2:45 am
Viewing 15 posts - 1 through 15 (of 24 total)