Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,131 through 14,145 (of 59,095 total)

RE: Smalldatetime

Stewart "Arturius" Campbell - Tuesday, October 10, 2017 1:16 AM
Nice one, thanks Steve
even though Microsoft themselves recommend using the new date/time formats...
--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)

October 11, 2017 at 9:10 am

#1963203
RE: Grouping Multiple Lines to One

nicolestrain07 - Wednesday, October 11, 2017 2:43 AM
Hello,
Im trying to combine multiple lines to one like the below example.
I looked 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)

October 11, 2017 at 8:57 am

#1963198
RE: query format

MinhL7 - Wednesday, October 11, 2017 6:00 AM
Jeff Moden - Sunday, October 8, 2017 11:45 PM
--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)

October 11, 2017 at 8:32 am

#1963193
RE: Options to run BCP in SQL Server

sqlenthu 89358 - Tuesday, October 10, 2017 11:17 AM
Guys, I am little confused here w.r.t. permissions. When I tried BCP load from...
--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)

October 10, 2017 at 11:22 am

#1963092
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AM
This was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html
Wow! Just ... WOW! ...
--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)

October 10, 2017 at 11:14 am

#1963083
RE: Alter LDF File Max Size

Chris Harshman - Tuesday, October 10, 2017 10:12 AM
jstites - Monday, October 9, 2017 4:54 PM
--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)

October 10, 2017 at 10:48 am

#1963074
RE: Fun Conversions

Ed Wagner - Tuesday, October 10, 2017 5:24 AM
I remember the thread this question came from. It made an excellent QOTD.
Bwaa-haaa!!! Thank...
--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)

October 10, 2017 at 5:47 am

#1962979
RE: Reversing visibility of spam forum threads

There is a definite pattern to most of the spam posts... I don't understand why their spam detector hasn't learned from all the spam reports.
I've stopped reporting...
--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)

October 10, 2017 at 5:38 am

#1962977
RE: Stored procedure is taking too long to execute.

It's not possible to troubleshoot such a stored procedure without the correct information. Please see the second link in my signature line below under "Helpful Links" for the right way...
--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)

October 9, 2017 at 5:49 pm

#1962924
RE: Alter LDF File Max Size

Hi Chris,
Thanks for the handy query. Can you tell me what it means that the majority of my data is coming from .Net SqlClient...
--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)

October 9, 2017 at 5:28 pm

#1962922
RE: Delete DB, where physical files are missing

dan.brown1 - Monday, October 9, 2017 5:18 PM
Drop alone is not working and gives the same error.
Also, right click is giving 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)

October 9, 2017 at 5:19 pm

#1962921
RE: Delete DB, where physical files are missing

dan.brown1 - Monday, October 9, 2017 1:17 PM
Got a situation, the storage location where the physical DB files existing is been deleted...
--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)

October 9, 2017 at 3:45 pm

#1962910
RE: Alter LDF File Max Size

jstites - Monday, October 9, 2017 1:02 PM
Hi,
The product I support does a FULL backup nightly as well as log backup every...
--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)

October 9, 2017 at 1:56 pm

#1962889
RE: Options to run BCP in SQL Server

sqlenthu 89358 - Monday, October 9, 2017 11:52 AM
Hi All, the question might be stupid but as a quick fix want 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)

October 9, 2017 at 1:43 pm

#1962885
RE: Comparing 2 functions for any differences in the result set.

p.s. I also asked if you would post both functions that you're testing so that we might be able to 1) understand more of your testing requirements so that we...
--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)

October 9, 2017 at 10:51 am

#1962863

Viewing 15 posts - 14,131 through 14,145 (of 59,095 total)