Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,571 through 15,585 (of 59,101 total)

RE: Active Directory -> SQL (Convert)

Referencing the following URL ...
https://msdn.microsoft.com/en-us/library/ms675098(v=vs.85).aspx
... and if you only want the date and not the time, you can do the following...
DECLARE @AcctExpires VARCHAR(32) =...
--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)

February 24, 2017 at 8:28 pm

#1930301
RE: SQL Server Trace Flags - Complete list

kast218 - Thursday, February 23, 2017 9:11 AM
Jeff Moden - Thursday, February 23, 2017 5:45 AM
--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)

February 23, 2017 at 7:55 pm

#1930086
RE: Are the posted questions getting worse?

jasona.work - Thursday, February 23, 2017 2:19 PM
Someone, somewhere, is up to mischief...
That would be 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)

February 23, 2017 at 7:50 pm

#1930084
RE: Store Procedure

Steve Jones - SSC Editor - Thursday, February 23, 2017 7:02 PM
I absolutely use a tally table, but I may use a...
--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)

February 23, 2017 at 7:40 pm

#1930083
RE: Data import files

Ed Wagner - Thursday, February 23, 2017 3:39 PM
I do BULK INSERT all the time, but not on SQL 2016 yet. 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)

February 23, 2017 at 7:37 pm

#1930081
RE: Query Cost Relative to the Batch vs. statistics io vs. Extended Events

SoCal_DBD - Thursday, February 23, 2017 1:39 PM
Thank you Jeff and Scott.
That said, is there ever any case or reason why one...
--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)

February 23, 2017 at 6:20 pm

#1930077
RE: Performance improves after reboot

cphite - Thursday, February 23, 2017 1:48 PM
RVO - Wednesday, February 22, 2017 8:01 AM
--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)

February 23, 2017 at 6:11 pm

#1930076
RE: Store Procedure

Steve Jones - SSC Editor - Thursday, February 23, 2017 2:59 PM
I can't say it's my idea. I'm not sure if this...
--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)

February 23, 2017 at 3:57 pm

#1930066
RE: Store Procedure

Nita Reddy - Thursday, February 16, 2017 8:57 AM
I have a store Procedure which generate output as one random number
I need 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)

February 23, 2017 at 3:16 pm

#1930057
RE: The Cloud is Just a Tool

Eric M Russell - Thursday, February 23, 2017 1:07 PM
Jeff Moden - Thursday, February 23, 2017 12:49...
--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)

February 23, 2017 at 3:07 pm

#1930055
RE: Performance improves after reboot

adb2303 - Thursday, February 23, 2017 12:46 PM
Jeff Moden - Thursday, February 23, 2017 10:53 AM
--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)

February 23, 2017 at 12:56 pm

#1930034
RE: The Cloud is Just a Tool

What do the security problems have to do with "the cheese"?
--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)

February 23, 2017 at 12:49 pm

#1930033
RE: Query Cost Relative to the Batch vs. statistics io vs. Extended Events

+1000 Second 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)

February 23, 2017 at 11:28 am

#1930015
RE: The Cloud is Just a Tool

Eric M Russell - Thursday, February 23, 2017 11:07 AM
The cloud is just somebody else's data center. The tools are essentially 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)

February 23, 2017 at 11:26 am

#1930013
RE: how to convert varchar value to datetime

Phil Parkin - Thursday, February 23, 2017 11:10 AM
mcfarlandparkway - Thursday, February 23, 2017 10:58 AM
--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)

February 23, 2017 at 11:23 am

#1930011

Viewing 15 posts - 15,571 through 15,585 (of 59,101 total)