Viewing 15 posts - 991 through 1,005 (of 2,462 total)
Jacob Wilkins (2/19/2016)
kkilsby (2/19/2016)
-- Itzik Ben-Gan 2001
February 22, 2016 at 8:21 am
Bill Talada (2/19/2016)
I often create two filtered indexes when I have a need for an OR.
What does that accomplish?
-- Itzik Ben-Gan 2001
February 19, 2016 at 8:15 am
How many of you have gotten up before dawn, driven to the coast, gotten on a long piece of fiberglass and paddled into the ocean before turning around to ride...
-- Itzik Ben-Gan 2001
February 17, 2016 at 2:41 pm
Jacob Wilkins (2/17/2016)
Alan.B (2/17/2016)
The UpdateDt column in the Users table is DATETIME so I wouldn't expect any datatype conversion issues.
Perhaps... To know for sure check the query plan (the actual...
-- Itzik Ben-Gan 2001
February 17, 2016 at 2:38 pm
No problem. 😎
-- Itzik Ben-Gan 2001
February 17, 2016 at 2:33 pm
The UpdateDt column in the Users table is DATETIME so I wouldn't expect any datatype conversion issues.
Perhaps... To know for sure check the query plan (the actual query plan, not...
-- Itzik Ben-Gan 2001
February 17, 2016 at 2:31 pm
Sergiy (2/17/2016)
Make the PK on UserID non-clustered and create a clustered index on UpdateDt.
Unless UpdateDt is not unique. Then perhaps a clustered index on composite key consisting of UpdateDt and...
-- Itzik Ben-Gan 2001
February 17, 2016 at 2:25 pm
Use the UPPER function.
-- Itzik Ben-Gan 2001
February 17, 2016 at 2:22 pm
The SQL Server Analysis Services (SSAS) Tutorial[/url] on mssqltips aint bad as it uses adventureworks as an example which is available online for free. If you are serious, I strongly...
-- Itzik Ben-Gan 2001
February 17, 2016 at 2:20 pm
Did what I posted help?
-- Itzik Ben-Gan 2001
February 17, 2016 at 1:58 pm
Implicit conversion is treating your '' value as a zero and making the column a numeric column. When you query a numeric column:
WHERE Column3 = ''
is the same...
-- Itzik Ben-Gan 2001
February 17, 2016 at 11:23 am
Eric M Russell (2/17/2016)
Local user group meetings offer a similar experience. Also, you can find tons of recorded presentations on sites like YouTube and SQLBits.
+1
There's so much good free...
-- Itzik Ben-Gan 2001
February 17, 2016 at 10:45 am
Luis Cazares (2/17/2016)
You might want to reduce your varchar length. I've never heard of a common use for such large numbers.
haha - I missed the comment about converting to varchar(100)....
-- Itzik Ben-Gan 2001
February 17, 2016 at 10:40 am
When Redgate SQL in the City comes around that's similar to SQL Saturday. I know this was not your question but it's worth mentioning.
I don't know about the other...
-- Itzik Ben-Gan 2001
February 17, 2016 at 10:01 am
Here's two options:
DECLARE @table TABLE (CashFlowCoverage int);
INSERT @table VALUES (1),(2),(-999),(999);
SELECT CashFlowCoverage = NULLIF(NULLIF(CashFlowCoverage,-999),999)
FROM @table;
SELECT CashFlowCoverage = NULLIF(ABS(CashFlowCoverage),999)
FROM @table;
EDIT: changed the column name
-- Itzik Ben-Gan 2001
February 17, 2016 at 9:54 am
Viewing 15 posts - 991 through 1,005 (of 2,462 total)