Viewing 15 posts - 5,416 through 5,430 (of 7,597 total)
Jeff Moden (1/26/2015)
ScottPletcher (1/26/2015)
dwain.c (1/25/2015)
coalesce(a.processStatus, 0) = 0
is not SARGable, so that could be improved on by making the processStatus column NOT NULL.
It's much better to code it as:
(a.processStatus...
January 27, 2015 at 9:09 am
dwain.c (1/25/2015)
coalesce(a.processStatus, 0) = 0
is not SARGable, so that could be improved on by making the processStatus column NOT NULL.
It's much better to code it as:
(a.processStatus is null or...
January 26, 2015 at 1:56 pm
g.britton (1/26/2015)
Jeff Moden (1/24/2015)
RonKyle (1/24/2015)
What are the issues with DATETIME2 and DATEDIFF?
Simple. Given a single row that contains StartDate and EndDate columns as DATETIME2 columns, write the code to...
January 26, 2015 at 1:42 pm
TomThomson (1/23/2015)
ScottPletcher (1/23/2015)
TomThomson (1/23/2015)
Sean Lange (1/23/2015)
Eric M Russell (1/23/2015)
Date/Time: datetime, offset, varchar?There is only one option here. Datetime.
I suppose if your dBMS is anccient enough that's excusable. But...
January 23, 2015 at 1:25 pm
TomThomson (1/23/2015)
Sean Lange (1/23/2015)
Eric M Russell (1/23/2015)
Date/Time: datetime, offset, varchar?There is only one option here. Datetime.
I suppose if your dBMS is anccient enough that's excusable. But it probably...
January 23, 2015 at 12:50 pm
MMartin1 (1/23/2015)
EXEC SP_HELPTEXT 'schema.viewName';This formats the output across multiple lines rather than just one. I find it way handier when copying long definitions to the SSMS window.
True; it's easier to...
January 23, 2015 at 11:43 am
I'm stunned Celko hasn't weighed in and told us how to name things properly rather than relying on punched cards and tape naming!
January 23, 2015 at 9:44 am
Phil Parkin (1/23/2015)
ScottPletcher (1/23/2015)
Phil Parkin (1/23/2015)
Steve Jones - SSC Editor (1/23/2015)
January 23, 2015 at 9:43 am
Phil Parkin (1/23/2015)
ScottPletcher (1/23/2015)
Phil Parkin (1/23/2015)
Steve Jones - SSC Editor (1/23/2015)
January 23, 2015 at 9:32 am
I think it's just that some company -- probably Microsoft -- did it in some of their early tables and people copied it without reflecting on whether it needed changed...
January 23, 2015 at 9:17 am
Phil Parkin (1/23/2015)
Steve Jones - SSC Editor (1/23/2015)
ProductId would look...
January 23, 2015 at 9:08 am
I don't get why just "ID" is fully capitalized. Why not "addr"?
Why is it:
ProductID
but:
ProductAddr
rather than:
ProductADDR
Why selectively capitalize just one abbreviation? Why the inconsistency?
January 23, 2015 at 8:33 am
I prefer product_id. Using mixed case is a real p.i.t.a. on a case-sensitive server!!
But, ProductId seems right to me if you're going to camel case.
For example, say you had...
January 22, 2015 at 4:09 pm
You can use either:
function "fn_listextendedproperty"
or directly read view "sys.extended_properties"
January 22, 2015 at 3:56 pm
A script that purports to "check" settings should NOT change them, period. Even more so without a warning/statement that they've been changed!
If a specific setting needs to be changed...
January 22, 2015 at 10:02 am
Viewing 15 posts - 5,416 through 5,430 (of 7,597 total)