Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,366 through 10,380 (of 59,099 total)

RE: need 3rd day of Calendar month - date precision to exclude minutes

For more info on DATEPART, please see the article at the following link.
https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-2017
There's also a wealth of knowledge just a click away in the menu...
--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)

December 16, 2018 at 11:48 am

#2016411
RE: need 3rd day of Calendar month - date precision to exclude minutes

polkadot - Sunday, December 16, 2018 11:14 AM
I need query (in my case an INSERT) to run only if today's date 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)

December 16, 2018 at 11:26 am

#2016410
RE: Email results of Failed Jobs

Why wouldn't you use an INSERT/SELECT into a table and create the email from those results?
--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)

December 16, 2018 at 10:39 am

#2016408
RE: CREATE EXTERNAL DATA SOURCE

I'm not an Azure user by any means so be gentle, please... Azure doesn't have a BULK INSERT command or OPENROWSET? :blink:
--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)

December 16, 2018 at 10:36 am

#2016407
RE: Do recruiters primarily recruit for contract jobs?

Rod at work - Sunday, December 16, 2018 7:42 AM
Getting great feedback here, thanks. Looks like it is more where I live...
--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)

December 16, 2018 at 10:29 am

#2016406
RE: How to clean buffer cache without using DBCC command?

inshah2297 - Friday, December 14, 2018 5:15 AM
You shouldn't generally need to totally flush the cushions. Looking at Coherent I/O ought 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)

December 16, 2018 at 10:22 am

#2016405
RE: Automaticaly Build and Deploy SSIS packages.

@Phil...
As you know, I'm far from even being a casual user of SSIS never mind an authority of any kind on the subject but...Isn't the OP going to 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)

December 16, 2018 at 10:17 am

#2016404
RE: Range arguments

radu.popa 78500 - Friday, December 14, 2018 9:26 AM
So, if the 1st arg is optional, how does one call this function 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)

December 16, 2018 at 10:08 am

#2016403
RE: Issue with midnight in stored procedure

Disclaimer: I don't know beans about Java 😀 but the code looks correct for ordinal position of the inputs and the number of inputs (15) in all sections.
The...
--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)

December 16, 2018 at 10:05 am

#2016402
RE: PERCENTILE_DISC for median calculation

Run a test and find out. 😉 When you're done testing it, tell us what you found. 😀
--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)

December 16, 2018 at 9:34 am

#2016401
RE: The Wild Developers of SQL Server like Wildcards

Great article, Phil. I just worry about such improvements by MS especially if they resort to using .NET functionality behind the scenes.
For example, look at what they did...
--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)

December 16, 2018 at 9:21 am

#2016400
RE: SQL Server Active Directory helper?

inshah2297 - Friday, December 14, 2018 10:09 PM
When SQL Server is installed, a number of Windows Services are also installed depending on...
--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)

December 16, 2018 at 9:03 am

#2016398
RE: SQL Server Active Directory helper?

mayurambokar - Thursday, January 8, 2009 3:38 AM
HiI am not able to start SQL Server Active Directory helper in my server 2003....
--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)

December 16, 2018 at 8:53 am

#2016396
RE: Stumped trying to shred XML data into table rows

A fellow by the name of Orlando Colamatteo posted a trick for displaying long strings a long time ago at the following...
--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)

December 16, 2018 at 8:46 am

#2016395
RE: Subquery - another way to achieve the same result?

Since no one specifically identified it and with the idea of teaching a man to fish and how to unsnarl his reel, the other thing that Scott's code does 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)

December 16, 2018 at 8:17 am

#2016393

Viewing 15 posts - 10,366 through 10,380 (of 59,099 total)