Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,146 through 11,160 (of 59,095 total)

RE: Can db_ddladmin role permissions be limited to specific tables on a schema?

Brandie Tarvin - Monday, September 24, 2018 5:50 AM
Jeff Moden - Monday, September 17, 2018 9:36 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)

September 24, 2018 at 6:26 am

#2006716
RE: Insert 2k rows in one second

Hamid-Sadeghian - Sunday, September 23, 2018 12:00 PM
for example such as this link
Insert statement is very simple.
tables has 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)

September 23, 2018 at 4:42 pm

#2006680
RE: Insert 2k rows in one second

Hamid-Sadeghian - Saturday, September 22, 2018 1:12 PM
Hi ,
I have a bourse application that in beginning of the day , service application...
--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)

September 23, 2018 at 11:33 am

#2006674
RE: Multiple joins vs. 1 lookup table (alternatives)

info 58414 - Sunday, September 23, 2018 10:28 AM
Hi,
In a DataMart analysis for a CRM system, about 10 Dim tables are joined...
--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)

September 23, 2018 at 10:48 am

#2006672
RE: Insert 2k rows in one second

The original title of this post was "Insert 2k Rows in 2 seconds". I'm curious as to what problem you had and why you deleted your question. Did you come...
--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)

September 23, 2018 at 10:40 am

#2006671
RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

Improperly parameterized queries that cause recompiles, network latency, the fact that most connections made from the front end use different settings than what SSMS uses, overly busy or poorly configured...
--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)

September 23, 2018 at 10:30 am

#2006670
RE: Are there such things as SQL heresies?

Really cool article, Phil. Are there heresies in SQL Server or, more specifically for most of what I do, in T-SQL? There sure are and some of them are, indeed,...
--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)

September 23, 2018 at 10:06 am

#2006667
RE: How to get output of SP_HELP_JOB into a script?

Michael L John - Saturday, September 22, 2018 4:40 PM
prakashanand2223 - Saturday, September 22, 2018 1:13 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)

September 23, 2018 at 9:00 am

#2006665
RE: Fitting Into RAM

David.Poole - Sunday, September 23, 2018 5:40 AM
The ridiculous thing is that the cost of peoples time arguing why you shouldn't 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)

September 23, 2018 at 8:39 am

#2006664
RE: Line and Columns combination

drew.allen - Monday, September 17, 2018 8:49 AM
I don't consider this a CROSS JOIN. It's an INNER JOIN on GPID and Name. ...
--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)

September 23, 2018 at 8:28 am

#2006663
RE: Fitting Into RAM

jarick 15608 - Saturday, September 22, 2018 2:54 PM
Is it me or does anyone else get a lot of consultants who...
--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)

September 22, 2018 at 4:16 pm

#2006656
RE: How to get output of SP_HELP_JOB into a script?

prakashanand2223 - Saturday, September 22, 2018 1:13 AM
Jen-169507 - Thursday, February 16, 2006 8:58 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)

September 22, 2018 at 7:48 am

#2006647
RE: Convert Date

Lynn Pettis - Friday, September 21, 2018 9:42 AM
craig.jenkins - Friday, September 21, 2018 8:18 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)

September 21, 2018 at 10:06 pm

#2006643
RE: Which data to baseline before and after adding an index

webrunner - Friday, September 21, 2018 8:20 AM
Hello experts,
While troubleshooting a poorly performing query, I was able to have some success 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)

September 21, 2018 at 9:59 pm

#2006642
RE: Convert Date

Jonathan AC Roberts - Friday, September 21, 2018 9:04 AM
Jeff Moden - Friday, September 21, 2018 8:41...
--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)

September 21, 2018 at 9:22 am

#2006589

Viewing 15 posts - 11,146 through 11,160 (of 59,095 total)