Jeff Moden

Forum Replies Created

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

RE: Table Index

P.S. No wanting to rely on abbreviations, what does GDPR stand for in this case?
--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 19, 2017 at 9:25 am

#1964361
RE: Table Index

Hi David,
Having recently gone through some problems with several relatively large tables that were once the size you predict, I do have some suggestions for "bullet proofing". 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)

October 19, 2017 at 9:22 am

#1964359
RE: django (not the movie)

xsevensinzx - Thursday, October 19, 2017 7:16 AM
Sure. I've used Django with SQL Server, but have mostly switched to using Flask over...
--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 19, 2017 at 8:36 am

#1964354
RE: Having trouble displaying a date in a certain format...

crmitchell - Thursday, October 19, 2017 3:21 AM
chef423 - Wednesday, October 11, 2017 2:24 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 19, 2017 at 8:18 am

#1964349
RE: Extreme slowness

Steve Jones - SSC Editor - Wednesday, October 18, 2017 7:25 PM
We are experiencing some CPU issues on the web servers. 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)

October 19, 2017 at 7:57 am

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

I was able to get parallelism out of it by simplifying the function instead of the "Make Parallel" thing but now I'm dealing with an implicit cast that's making mine...
--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 19, 2017 at 12:15 am

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

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