Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,241 through 18,255 (of 59,069 total)

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
RE: CAST tinyint to nvarchar

Ed Wagner (2/26/2016)
Yeah, I tend to go with a very literal interpretation. As has been pointed out, a simple Error in the table would have helped. 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)

February 28, 2016 at 7:55 am

#1861691
RE: Deadlock help please

gary1 (2/27/2016)
Thanks Jeff,
I was not running any queries in SSMS. We were running bunch of sql scripts which will do some updates (it's a vendor application, will get an...
--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 7:45 am

#1861689
RE: The Dangers of Algorithms

Outstanding article, Steve. I'd discuss it a bit more but, being a customer/consumer of software, I would tick off the whole world with my thoughts in this area, so...
--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 27, 2016 at 7:34 pm

#1861668

Viewing 15 posts - 18,241 through 18,255 (of 59,069 total)