Jeff Moden

Forum Replies Created

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

RE: Are there such things as SQL heresies?

RonKyle - Monday, September 24, 2018 8:02 AM
I would still caution that too many "it depends" becomes "I'll do it like 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)

September 24, 2018 at 8:45 am

#2006752
RE: I have an idea how to reduce the number of meetings.

Heh.... It would be far easier to teach pigs to fly than it would be to train managers and other how to properly conduct and effective meeting. It's really difficult...
--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 8:40 am

#2006751
RE: Are the posted questions getting worse?

The real fact of the matter is that whether or not T-SQL is actually declarative or not, doesn't actually matter. It is what it is. The key is to get...
--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:43 am

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

jkramprakash - Sunday, September 23, 2018 11:21 PM
Jeff Moden - Sunday, September 23, 2018 10:30 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:31 am

#2006718
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

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