Viewing 15 posts - 316 through 330 (of 476 total)
I found Erland Sommarskog's articles on SQL Error Handling very helpful. They are very detailed, and very long, but gave me a lot of reassurance that I understood all aspects...
September 19, 2015 at 3:13 am
kevitra (9/18/2015)
September 19, 2015 at 2:57 am
When I show prospective employees fresh from college, at interview, how we do things they are usually fascinated and surprised and say things like "why didn't we learn this at...
September 19, 2015 at 2:45 am
al3408 (9/17/2015)
Took only 7 seconds to return 250k records
If you "retrieved" them? that might pretty much all be display time.
Perhaps measure the time of:
SELECT JustThePKeyColumn
INTO #TEMP
FROM ...
which will store the...
September 19, 2015 at 2:39 am
P.S. Discourse does have an import from some Forum software (dunno about the one used here). No way could be found to import, cost effectively, from SQLTeam's old forum...
September 19, 2015 at 1:16 am
SqlBarbarian (9/18/2015)
September 19, 2015 at 1:09 am
Wurstsalat (9/18/2015)
I`ve started reading Hallengren's script...and it is (for me) a bit complicated to read
I think that too. You can just use it "as it", and it has every...
September 18, 2015 at 11:13 am
Eric M Russell (9/18/2015)
September 18, 2015 at 11:04 am
Eirikur Eiriksson (9/18/2015)
I've found the method I use for timing more accurate than the time statistics
Ah ... 🙂 Not to dis Luis or anything, but when I ran the...
September 18, 2015 at 10:58 am
The front runners were neck-and-neck in Luis's script?
September 18, 2015 at 2:06 am
Can I be on commission pls? :w00t:
September 17, 2015 at 9:17 pm
SELECTpattern, expression
FROM@EXPRTABLE
JOIN @TRANSLATETABLE
ON expression LIKE REPLACE(pattern, '#', '%')
SELECTpattern, expression
FROM@EXPRTABLE
JOIN @TRANSLATETABLE
ON expression NOT LIKE REPLACE(pattern, '#', '%')
I would advise not to use that in production though - the REPLACE...
September 17, 2015 at 9:14 pm
When I post this reply the list of messages (below this Message Formfield) has your (FullStack's) messages displayed with a red background. I don't think I've ever seen that...
September 17, 2015 at 8:29 pm
If you just used "%" wildcard instead of "#" (or REPLACE it) and then did a LIKE I think that woudl match - but would that be a suitable solution?
September 17, 2015 at 8:22 pm
.Netter (9/17/2015)
I'm not sure what you mean in regards to chopping the userId to smallint? I think a Integer would be more then sufficient
If your User Base is less than...
September 17, 2015 at 8:19 pm
Viewing 15 posts - 316 through 330 (of 476 total)