Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,041 through 14,055 (of 59,095 total)

RE: Trying to speed up this 'GetWorkingDays' function.

I don't know what dbo.tfn_Tally(1000000, 1) does. Does it start at 1 and count to a million with an increment of 1?
--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 18, 2017 at 9:13 pm

#1964305
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Wednesday, October 18, 2017 6:00 PM
I have to believe that someone here has the magic go-fast this thing...
--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 18, 2017 at 7:08 pm

#1964302
RE: Shared stored procedure with very complicated input

mcraig 42832 - Wednesday, October 18, 2017 6:22 AM
Jeff Moden - Tuesday, October 17, 2017 8:12 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 18, 2017 at 11:13 am

#1964249
RE: SQL versus program

It's a well known fact that "managed" code can be and frequently is much slower and resource intensive than using properly optimized stored procedures. The key in this case is that no...
--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 18, 2017 at 8:45 am

#1964227
RE: MS-SQL 2016 Eating Memory

dextrous - Wednesday, October 18, 2017 5:02 AM
I just noticed that and I've changed it...
Thank guys for identifying the bloody obvious 😀
--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 18, 2017 at 8:03 am

#1964213
RE: Data row does not have a matching index row in the index

tony28 - Wednesday, October 18, 2017 7:06 AM
Hello,
I have this problem.
At monday found this, so drop and recreate index, then execute...
--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 18, 2017 at 7:48 am

#1964209
RE: How to get columns which has null's

Just a heads-up on this... this type of query can cause statistics to be constructed on every column it touches. That could cause some pretty good delays for INSERTs, UPDATEs,...
--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 18, 2017 at 6:54 am

#1964196
RE: Software Patents

I think the people granting patents such as the "1-click" thingy need to find a new job. They've obviously not done any due diligence when it comes to "prior art"...
--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 18, 2017 at 6:29 am

#1964193
RE: Code for 'week to date' DATETIME() mine is displaying previous weeks

chef423 - Tuesday, October 17, 2017 10:14 PM
SELECT '$' + CONVERT(VARCHAR(10), CAST([ie].[Amount] AS MONEY)),
Name = CASE WHEN...
--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 18, 2017 at 5:55 am

#1964190
RE: OPEN TEXTFILE FROM T-SQL

unas_sasing - Tuesday, October 17, 2017 8:50 PM
unas_sasing - Tuesday, October 17, 2017 8: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 18, 2017 at 5:52 am

#1964189
RE: TRUNCATE and INSERT INTO slower than TRUNCATE GO INSERT INTO

mrpellepelle - Wednesday, October 18, 2017 3:13 AM
Hi guys,
any other solutions / explanations for this behaviour?
I do not feel comfortable with...
--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 18, 2017 at 5:39 am

#1964187
RE: Shared stored procedure with very complicated input

mcraig 42832 - Tuesday, October 17, 2017 7:09 AM
So, the basics of what I want to accomplish is simple...I have a stored...
--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 17, 2017 at 8:12 pm

#1964136
RE: latest timestamp multiple databases

The shortest thing would be to write a query that reads from the table and inserts the results into a common table using the undocumented and unsupported sp_MSForEachDB stored procedure,...
--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 17, 2017 at 8:06 pm

#1964135
RE: Extract to CSV File

wweraw25 - Tuesday, October 17, 2017 6:04 PM
I have data something like below for one of the column.
ADDRESS
2248|("snake") ft NE, FTE 700
When...
--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 17, 2017 at 7:14 pm

#1964132
RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, October 17, 2017 4:53 PM
How do companies end up with people like this working with their databases?
The interviewers...
--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 17, 2017 at 6:24 pm

#1964128

Viewing 15 posts - 14,041 through 14,055 (of 59,095 total)