Viewing 15 posts - 6,541 through 6,555 (of 7,619 total)
ISNULL() has its own oddities:
DECLARE @var1 char(1)
SET @var1 = NULL
SELECT ISNULL(@var1, 'N/A') -- Result = 'N'
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 5, 2013 at 1:30 pm
I'd suggest using COALESCE also, keeping in mind the difference between it and ISNULL in regard to data types.
Given that, in this case you could explicitly CAST the 99 to...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 5, 2013 at 11:46 am
SELECT
mt.##col1##, ..., jt.##co11##, ...
FROM dbo.maintable mt
LEFT OUTER JOIN jointable jt ON
--ignore last two bytes of patid if they are alpha, because it's...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 1, 2013 at 2:25 pm
IIRC, partitioned views are allowed in Standard Edition (at least as long as you don't try to update using a distributed partitioned view?).
As I noted first, a truly partitioned table...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 24, 2013 at 2:04 pm
Ouch -- partitioning would be ideal for that situation.
Depending on exact circumstances, you might be able to change the current table to be a view that's defined as a concatenation...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 21, 2013 at 3:15 pm
While performance could be adversely affected, possibly severely, the really big problem, at least for a DBA, with data and logs for the same db on the same drive is...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 21, 2013 at 3:07 pm
You could implement some type of SNAPSHOT isolation level. That will prevent the types of errors you get with (NOLOCK) and prevent readers from being blocked by writers.
See Books...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 21, 2013 at 2:59 pm
Lynn Pettis (6/12/2013)
mmartin1 (6/12/2013)
gmac 41947 (3/1/2013)
Hi,I use
DATEPART(month, myDate)or
MONTH(myDate)the resut is: 2 (if myDate is 2013.02.03). I would like return: 02
Do you have any solution for this?
Thans!
try this
declare @MyDate datetime
set...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 12, 2013 at 2:41 pm
WHERE
',' + column + ',' LIKE '%[^a-z0-9]LC[^a-z0-9]%'
Add other char(s) if/as needed; for example, if you prefer that underscore, such as in "LC_AXIS", not be a "word"...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 12, 2013 at 1:57 pm
Evil Kraig F (6/6/2013)
ScottPletcher (6/6/2013)
At...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 7, 2013 at 9:26 am
Evil Kraig F (6/6/2013)
ScottPletcher (6/6/2013)
Evil Kraig F (6/6/2013)
ScottPletcher (6/6/2013)
Dird (6/6/2013)
Sean Lange (6/6/2013)
MID?
Yeah, the Q as a whole is a bit meh. I assume he means AVG (to go with the...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 6, 2013 at 3:54 pm
Evil Kraig F (6/6/2013)
ScottPletcher (6/6/2013)
Dird (6/6/2013)
Sean Lange (6/6/2013)
MID?
Yeah, the Q as a whole is a bit meh. I assume he means AVG (to go with the MIN/MAX functions) which I...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 6, 2013 at 3:43 pm
Dird (6/6/2013)
Sean Lange (6/6/2013)
MID?
Yeah, the Q as a whole is a bit meh. I assume he means AVG (to go with the MIN/MAX functions) which I don't see as a...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 6, 2013 at 3:33 pm
Sean Lange (6/6/2013)
ScottPletcher (6/6/2013)
Given table1 with columns "id" and "value", where each id has 1 to 3 values/rows in the table:
Describe the essentials of a single query (no subquery,...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 6, 2013 at 3:29 pm
Ask them::
Given table1 with columns "id" and "value", where each id has 1 to 3 values/rows in the table:
Describe the essentials of a single query (no subquery, CTE, etc.) to...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
June 6, 2013 at 3:01 pm
Viewing 15 posts - 6,541 through 6,555 (of 7,619 total)