Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,986 through 24,000 (of 59,099 total)

RE: Convert "TinyInt" into Binary format and store the multiple bit values in columns

Just a small simplification of Luis' fine code...
WITH SampleData AS(
SELECT 55 Value UNION ALL
SELECT 63 UNION ALL
SELECT 26
)
SELECT Value,
SIGN(Value & 64) AS Sat,
SIGN(Value & 32) AS Fri,
SIGN(Value & 16) AS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 10:29 pm

#1702719
RE: How to Tell If At Least 1 File Exists in A Collection of Subfolders

Such code is a little out of my league but I don't see where you're drilling down past the main folder at all.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 10:07 pm

#1702715
RE: The Internet of Things

I guess that pretty much puts the cap on the rumor that the cloud was going to kill the position of "DBA" in all it's wonderous mryiad of forms. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 10:03 pm

#1702713
RE: SQL Statement not displaying results with zero value

TheSQLGuru (4/2/2014)
http://msdn.microsoft.com/en-us/library/dd172122(v=vs.100).aspx
I don't see it listed here though, just the outer joins: http://technet.microsoft.com/en-us/library/bb510662.aspx
or here (although there are some rather surprising things supposedly being REMOVED in SQL 2014 and future...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 9:55 pm

#1702712
RE: Help need in Avoiding Loop

I sure do appreciate the positive feedback. Glad it's working for you.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 9:48 pm

#1702711
RE: Flexible Recursive Level Splitting - One column per level

Ok... first things first. This method needs a good, high performance string splitter. You can find a really good one in the article at the following link in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 9:18 pm

#1702709
RE: Help need in Avoiding Loop

Thanks for the feedback. What did your final code end up looking like? I ask only because I want to make sure that it won't be a problem...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 7:21 pm

#1702695
RE: Ideal table for Memory Optimization ?

milos.radivojevic (4/2/2014)
As with disk tables we would need your CREATE TABLE statement for the memory optimized table to check the table and index definition.
Since the ALTER TABLE statement is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 5:17 pm

#1702670
RE: How do you add a constraint for a VARCHAR(10) column to checks the Date format as yyyy/mm/dd

vanessa4biz (4/2/2014)
I agree with you hundred percent but this is a legacy system and management is afraid to change the data type in fear that it may cause other problems.
Understood....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 5:00 pm

#1702668
RE: how to do duration in hours with ragged data

drew.georgopulos (4/2/2014)
Thanks very much for the nudge...
I found this http://www.sqlperformance.com/2012/07/t-sql-queries/split-strings
which was great summation of the blizzard of solutions I found here, which was kind of an embarrassment of riches :-P.
I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 4:55 pm

#1702667
RE: Malicious files on the sql server found

george sibbald (4/2/2014)
I am sure you have already thought of it, but change the sa password or disable sa, turn off xp_cmdshell if you don't need it. By having sysadmin...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 4:14 pm

#1702657
RE: Best way to expose msdb information

ScottPletcher (4/2/2014)
If possible, I'd just add code to that job to write its status to a table in the other db. That way you could avoid referencing msdb at...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 4:01 pm

#1702654
RE: How do you add a constraint for a VARCHAR(10) column to checks the Date format as yyyy/mm/dd

Sean Lange (4/2/2014)
vanessa4biz (4/2/2014)
I have tried:
ALTER TABLE dbo.tablename
ADD CONSTRAINT DF_Date_format
check (SDate LIKE '%[1-2][0-9][0-9][0-9]/[0-1][0-9]/[0-3][0-9]%')
******But this does not work for VARCHAR data type...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 3:56 pm

#1702653
RE: A Questionable Trigger

Hugo Kornelis (4/2/2014)
The UPDATE ... FROM used in the trigger is a highly dangerous construction that, if I had my way, would have been deprecated a long time ago already.
I'm...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 3:16 pm

#1702648
RE: A Questionable Trigger

Carlo Romagnano (4/2/2014)
In sqlserver 2008 r2 the update doesn't return any resultset and no error message.
(2 row(s) affected)
(2 row(s) affected)
What I'm missing?
Same here.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 2, 2014 at 3:12 pm

#1702646

Viewing 15 posts - 23,986 through 24,000 (of 59,099 total)