Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,281 through 17,295 (of 59,102 total)

RE: What is the best to remove xp_cmdshell calls from t-sql code

j-1064772 (7/15/2016)
Jeff Moden (5/6/2016)
I'm with Ed. The auditing software is incorrect. Properly used, xp_CmdShell isn't a security problem.
I am not familiar with proxy accounts and even less on...
--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)

July 15, 2016 at 9:28 pm

#1890446
RE: Running Remaining Balance or Running Subtraction - Partition By Account

TheSQLGuru (6/7/2016)
Believe it or not, prior to SQL Server 2012 and it's enhanced Windowing Function support the most efficient way to do running-total style calculations in SQL Server is 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)

July 15, 2016 at 8:28 pm

#1890443
RE: Running Remaining Balance or Running Subtraction - Partition By Account

venkyzrocks (6/17/2016)
Hi Jeff,
I have modified the original script. Here's the entire script (DDL + Cursor Script)
IF OBJECT_ID (N'dbo.Account_Tagging', N'U') IS NOT NULL
AND EXISTS(SELECT * from dbo.Account_Tagging)
drop table Account_Tagging
BEGIN
CREATE...
--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)

July 15, 2016 at 7:11 pm

#1890442
RE: Are the posted questions getting worse?

Ray K (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)
I once had a friend tell...
--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)

July 15, 2016 at 4:18 pm

#1890438
RE: Execution plan differences in QA and Prod

You also need to make sure that statistics are up to date on the tables involved and you also need to consider differences in table volume and range(s) of data...
--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)

July 15, 2016 at 12:54 pm

#1890414
RE: t-sql large data size

@wendy,
I'll recommend again that you get a copy of Books Online (BOL for short) and use it. It clearly stated under the TEXT datatype that it is what has...
--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)

July 15, 2016 at 11:53 am

#1890387
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

asutorius (7/15/2016)
I was curious how these two concatenate examples compared in speed, I placed the examples in their own tabs in my local Sql Server 2014 and turned on Include...
--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)

July 15, 2016 at 11:11 am

#1890376
RE: Simple CLR request

Alan.B (7/12/2016)
CELKO (7/12/2016)
-1 is a wonderful answer.
To what? Who are you trying to communicate with here?
Mixed systems (those with more than one language embedded in each other) are always...
--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)

July 14, 2016 at 8:47 pm

#1890223
RE: Get start and end date row by row calculation based on duration

See this article (http://www.sqlservercentral.com/articles/T-SQL/61539/) for why Eirikur says "for small data sets". And it doesn't take many rows for the problem to become HUGE.
I don't, however, see this problem...
--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)

July 13, 2016 at 7:01 pm

#1889998
RE: Simple CLR request

Alan.B (7/13/2016)
CELKO (7/13/2016)
-1 is a wonderful answer. Mixed systems (those with more than one language embedded in each other) are always inefficient and a nightmare for anyone to read or...
--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)

July 13, 2016 at 3:14 pm

#1889980
RE: which is better to user the cross join or while loop ?

ChrisM@Work (10/12/2012)
nitin.varshney (10/12/2012)
Hi
Please tell me which is better for the performance impact ?
1. Insert into #temp table Using the cross join with tables.
2. Insert into #temp table using 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)

July 13, 2016 at 2:32 pm

#1889970
RE: How to use a table value function that splits a string

NineIron (7/13/2016)
I have a TVF that takes two parameters, string and delimter but, I don't know how to pass the field values into the function in order to get my...
--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)

July 13, 2016 at 1:34 pm

#1889948
RE: Odd (to me) Behavior with NTILE() and NULL Values in Source Data

Alan.B (2/25/2016)
The NTally Inline Table Valued Function
N-I-I-I-I-C-E! Great documentation, too!
--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)

July 13, 2016 at 1:12 pm

#1889946
RE: A problem of concurrency on a small table

paolobianchi (7/13/2016)
Hi all,
i have a problem on an application.
Details:
Table AAA, about 500 records, not growing
Many users (about 100) make a read from this table, many times (about 120 times for...
--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)

July 13, 2016 at 10:22 am

#1889914
RE: Generate Repeating Set of Row_Number values

douglashwilliams (7/12/2016)
Hello -
I have a table that contains a set of rows, where each row can represent a query to run. I have an ETL process that I can...
--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)

July 12, 2016 at 6:41 pm

#1889749

Viewing 15 posts - 17,281 through 17,295 (of 59,102 total)