Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,281 through 20,295 (of 59,098 total)

RE: How to subtract dates from previous date on same patient?

RTaylor2208 (6/23/2015)
I can't take credit for the function. I had that in useful scripts stored on my machine. But its definitely from a blog online.
The rest was me...
--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)

June 23, 2015 at 7:47 am

#1807361
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

I've never seen such problems as you mention with SELECT/INTO Leo but that doesn't mean they don't exist. Thanks for the warning.
--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)

June 23, 2015 at 7:39 am

#1807356
RE: Audit administrative logins

JManuelN (6/23/2015)
Hi,
One option could be enabling security audit (if the SQL Server edition allows it) and set the log file to a protected folder with no write permissions for 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)

June 23, 2015 at 7:36 am

#1807353
RE: How to subtract dates from previous date on same patient?

I haven't tried that code but it looks right. Heh... I definitely recognize the "workday" code.
--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)

June 23, 2015 at 7:32 am

#1807350
RE: Partition an existing SQL Server Table

Actually, DBA from the Cold provided a pretty good summary for you to easily follow. I'm not begging off but my presentation material is a whole lot more complicated...
--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)

June 23, 2015 at 7:31 am

#1807348
RE: Partition an existing SQL Server Table

I'd do RANGE RIGHT because it seems to be the method that humans understand where the partition date is the first date of the partition rather than the last.
I have...
--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)

June 23, 2015 at 7:04 am

#1807337
RE: Any idea why this is slow

mw112009 (6/22/2015)
This is very slow
Update #acrc
Set sbp_mbp = [RESEARCH].[dbo].[determine_num_of_mins_exceed_5_where_SBP_MAP_is_less_than_a_certain_value](Case_ID);
However if I do a
Select @sbp_mbp= [RESEARCH].[dbo].[determine_num_of_mins_exceed_5_where_SBP_MAP_is_less_than_a_certain_value]('12345');
--This gets executed within a few seconds
Gail and the others are correct. If 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)

June 22, 2015 at 10:54 pm

#1807241
RE: Repair Corrupt Access Database File

bgalway (6/22/2015)
I saw this problem recently and it turned out a Cryptovirus had encrypted the mdb. You might want to check other .mdb files just in case. And pray that...
--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)

June 22, 2015 at 9:58 pm

#1807240
RE: Partition an existing SQL Server Table

To be absolutely honest, the table has only about 25 million rows in it and, unless it's a very wide table or unless it has some massive data stored 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)

June 22, 2015 at 9:53 pm

#1807239
RE: Error using "Update" and "Set" commands

SandyTucker (6/22/2015)
Well it would seem I thought this code was working. But what is happening is that after it runs, the update occurs. But the change isn't permanent. Some time...
--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)

June 22, 2015 at 6:30 pm

#1807230
RE: Error using "Update" and "Set" commands

SandyTucker (6/22/2015)
Wow Jeff thank you so much for all your valuable insight! I had started with something a little more like this as far as assigning a shortened value...
--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)

June 22, 2015 at 6:20 pm

#1807228
RE: detach db

charipg (6/21/2015)
my script is working.
Thanks.
Can you post the script that's actually working for you please? Thanks.
--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)

June 22, 2015 at 5:37 pm

#1807225
RE: Are the posted questions getting worse?

Eirikur Eiriksson (6/22/2015)
ChrisM@Work (6/22/2015)
Alvin Ramard (6/22/2015)
GilaMonster (6/22/2015)
It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've...
--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)

June 22, 2015 at 12:53 pm

#1807161
RE: Audit administrative logins

Yowch. £6000 is almost $10,000USD. That's just crazy.
--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)

June 22, 2015 at 12:49 pm

#1807158
RE: How to subtract dates from previous date on same patient?

NineIron (6/22/2015)
Jeff, Any thoughts on excluding weekends when subtracting the two dates?
Absolutely but I don't like to post until after I've tested my code and I won't be able to...
--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)

June 22, 2015 at 12:42 pm

#1807156

Viewing 15 posts - 20,281 through 20,295 (of 59,098 total)