Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,271 through 18,285 (of 59,102 total)

RE: How to get recursive CTE at least 3000 times faster?

samuel.johnson (3/1/2016)
I am projecting often to be at least 3000/year and up to at least 30,000/year. I have yet to design this update mechanism. I have trouble thinking in terms...
--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)

March 1, 2016 at 9:08 pm

#1862274
RE: Can I improve performance by breaking my databases up?

This is nearly identical to another post. I recommend keeping any answers together on that other post, which is located at the following thread...
http://www.sqlservercentral.com/Forums/Topic1765710-3077-1.aspx
--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)

March 1, 2016 at 9:01 pm

#1862273
RE: 'Refresh' data only from Prod to Test environments

n.heyen (2/29/2016)
The development team is asking me to refresh data from Prod to Test without overwriting any stored procedures they might have on Test. So before I tell them 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)

March 1, 2016 at 8:59 pm

#1862272
RE: Creating a shared stored procedures accessing data from different schemas

Kenneth-1467 (2/29/2016)
We have a technical requirement to implement a multi tenant architecture where each of the tenants are separated using schema's. Our solution is to only allow access 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)

March 1, 2016 at 8:46 pm

#1862269
RE: How to get recursive CTE at least 3000 times faster?

samuel.johnson (3/1/2016)
...since they must often be updated when new individuals are added to the records.
How often is "often"? I ask because I have a plan.
Also, is this for some...
--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)

March 1, 2016 at 8:36 pm

#1862266
RE: Report take a long time and time out

WHug (3/1/2016)
From what I have seen, if the report has been fast (in SSRS) and now suddenly is slow (still in SSRS) then an index has become too fragmented 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)

March 1, 2016 at 8:15 pm

#1862262
RE: Rollback if ETL fails

moid.hassan (3/1/2016)
Hi,
Need an advice on rolling back the ETL load if anything fails.
I have a one truncate-and-load ETL process that runs every night, it first truncates the fact tables and...
--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)

March 1, 2016 at 7:57 pm

#1862259
RE: How multiple pivot query

TeknikServis27 (3/1/2016)
hi steve ,
for example
SET LANGUAGE Turkish;
SELECT '2016' Company , [Ocak],[1],[Subat],[2]
FROM (
SELECT ISNULL(st.AMOUNT, 0) AS miktar,
DATENAME(mm, DATE_) AS ay,
...
--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)

March 1, 2016 at 7:56 am

#1862107
RE: IDEs sweet but beguiling

xsevensinzx (2/29/2016)
Jeff Moden (2/29/2016)
GeorgeCopeland (2/29/2016)
Earlier I said that professionalism can help with the easy-IDE problem. Newbie bashing is probably unprofessional.
Is the GUI/IDE a bad thing? No, but the posers,...
--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)

February 29, 2016 at 10:20 pm

#1862008
RE: IDEs sweet but beguiling

patrickmcginnis59 10839 (2/29/2016)
Jeff Moden (2/29/2016)
patrickmcginnis59 10839 (2/29/2016)
Jeff Moden (2/27/2016)
This is a really good article, Phil. It actually echoes what Bill Gates predicted back in the '80s when he said...
--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)

February 29, 2016 at 5:49 pm

#1862000
RE: IDEs sweet but beguiling

GeorgeCopeland (2/29/2016)
Earlier I said that professionalism can help with the easy-IDE problem. Newbie bashing is probably unprofessional.
I don't consider it to be "newbie bashing" and I'll go to the wall...
--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)

February 29, 2016 at 5:45 pm

#1861999
RE: Deadlock help please

gary1 (2/28/2016)
Hi Jeff and Ed,
I was able to get procedure name and its code (line 39). But my question is:
1. how to find what was running in SSMS 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)

February 29, 2016 at 11:03 am

#1861880
RE: IDEs sweet but beguiling

patrickmcginnis59 10839 (2/29/2016)
Jeff Moden (2/27/2016)
This is a really good article, Phil. It actually echoes what Bill Gates predicted back in the '80s when he said that, soon, there would...
--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)

February 29, 2016 at 10:41 am

#1861873
RE: Deadlock help please

gary1 (2/28/2016)
Thank you very much Jeff,
It's a vendor application and we don't own their code and the application update will happens through exe.
My main worry is to find out if...
--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)

February 28, 2016 at 12:07 pm

#1861697
RE: Insert file to sql server without front end using Stored Procedure

Hugo Kornelis (2/28/2016)
Before going down this path further, I urge you to read up on dynamic SQL. Here is a (lengthy but) great resource: http://www.sommarskog.se/dynamic_sql.html. If you are not aware...
--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)

February 28, 2016 at 8:47 am

#1861692

Viewing 15 posts - 18,271 through 18,285 (of 59,102 total)