Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,596 through 14,610 (of 59,101 total)

RE: Hiring Guitarists

patrickmcginnis59 10839 - Wednesday, August 16, 2017 11:32 AM
"The "what", "why", "when", and "how" is important to being able to do...
--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)

August 18, 2017 at 7:52 pm

#1955894
RE: Subroutines in TSQL

@Lynn,
Consider the use of QUOTENAME in your REPLACE to help mitigate SQL Injection even when you use hard-coded brackets.
--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)

August 17, 2017 at 12:02 pm

#1955705
RE: Subroutines in TSQL

dmeissner - Thursday, August 17, 2017 7:48 AM
Listen guys, I apologize for getting uptight. Maybe you guys do things different here by...
--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)

August 17, 2017 at 11:45 am

#1955698
RE: Subroutines in TSQL

dmeissner - Tuesday, August 15, 2017 10:54 PM
Lyle,
I'm sorry you don't understand that this is a hypothetical example. There is no schema except that which the viewer chooses. Variables such as my_database, my_table, and my_column are clearly placeholders where one can simply swap out to match their schema. Nothing more.
I didn't feel it was necessary to include code for creating...
--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)

August 16, 2017 at 10:29 pm

#1955600
RE: Query performance tuning - Slow execution time

Jonathan AC Roberts - Tuesday, August 15, 2017 11:52 AM
With these type of query you can sometimes get a lot of success...
--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)

August 16, 2017 at 6:04 pm

#1955592
RE: Can I restore a single file .mdf to multiple files spread across disks

Arsh - Wednesday, August 16, 2017 1:56 PM
See how much free space you have in the database. If it's huge and if...
--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)

August 16, 2017 at 5:54 pm

#1955591
RE: Stairway to Test Automation and Continuous Integration for Databases Level 1: Why You Need TDD

Duncan A. McRae - Monday, February 29, 2016 12:41 PM
Much time has elapsed. Is this series dead?
Must've been outsourced. 😉
--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)

August 16, 2017 at 7:47 am

#1955484
RE: Hiring Heterogeneously

Nancy.Balcer - Wednesday, July 24, 2013 4:52 PM
Companies run lean, and it seems to me it's more often than not--difficult for analysts...
--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)

August 15, 2017 at 10:08 pm

#1955391
RE: Hiring Guitarists

Andrew..Peterson - Tuesday, August 15, 2017 1:53 PM
Jeff Moden - Monday, August 14, 2017 1:22 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)

August 15, 2017 at 9:38 pm

#1955388
RE: Query performance tuning - taking more than 9 minutes

ffarouqi - Monday, August 14, 2017 10:52 PM
Jonathan AC Roberts - Monday, August 14, 2017 8:42 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)

August 15, 2017 at 7:43 pm

#1955382
RE: Subroutines in TSQL

dmeissner - Monday, August 14, 2017 5:48 PM
Not sure exactly what you are getting at. This is an ad-hoc process that can be used for any schema with minimal tweaking. Schema is relative. The user has asked for an example of how the functionality...
--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)

August 15, 2017 at 7:47 am

#1955290
RE: Microsoft SQL Server Utilities and Tools

robert.sterbal 56890 - Thursday, July 20, 2017 12:31 PM
Jeff Moden - Thursday, July 20, 2017 12:16 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)

August 14, 2017 at 1:49 pm

#1955217
RE: Hiring Guitarists

I still think it's horrible that 20 out of 22 "guitarist" applicants we had don't know what a fret is or where the neck of the guitar actually 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)

August 14, 2017 at 1:22 pm

#1955214
RE: Subroutines in TSQL

dmeissner - Monday, August 14, 2017 7:57 AM
Wow, triggered again.
Heh... nah... just responding to that chip you're carrying. 😉 When you drop it, I'll...
--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)

August 14, 2017 at 1:15 pm

#1955211
RE: Subroutines in TSQL

dmeissner - Monday, August 14, 2017 12:19 PM
I already did.
"I did run across the thread searching for the same thing for an old mssql...
--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)

August 14, 2017 at 1:14 pm

#1955210

Viewing 15 posts - 14,596 through 14,610 (of 59,101 total)