Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,341 through 17,355 (of 59,102 total)

RE: not able to find why/where this error is comming.

rajemessage 14195 (7/5/2016)
i known begin tran and try cache , what i am asking is, which stmt might be the reason of generating this error.
your sincerley
BEGIN TRAN and TRY/CATCH are...
--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 5, 2016 at 2:02 pm

#1888562
RE: CTE Script Needed for delete statement

Sree Divya (6/29/2016)
Hi,
we are using below script for delete records.but it is taking time
USE AdventureWorks2008R2;
GO
DELETE * FROM Purchasing.PurchaseOrderDetail
WHERE DueDate = '20020701';
GO
is there any possibility of chance to delete the rows...
--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 5, 2016 at 1:15 pm

#1888548
RE: Reclaiming space after data type change

david.fundakowski (7/5/2016)
I would like to do a write up on table size increase after changing column data types and how to reclaim the empty space.
Topics included would be:
Changing...
--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 5, 2016 at 11:50 am

#1888527
RE: Decreasing a value across multiple rows until 0

greg.senne (7/5/2016)
Hey, I'm still here! It was a holiday weekend! Guess I should've checked in over the weekend...
So, this procedure is being used for payment deductions. The base table holds...
--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 5, 2016 at 8:10 am

#1888460
RE: Unstructured data sources into a structured DW

You bet and thanks for the feedback. Sorry I don't know of a better answer. These types of problems are really tough. Heh... how can you find...
--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 5, 2016 at 8:01 am

#1888458
RE: HTML Backup Report Design Considerations & T-SQL script

ffarouqi (7/4/2016)
It should be a simple HTML format...same as what they have shown in one of the examples in books online. Can you provide me with that formatting?
Regards,
Feivel.
Formatting table output...
--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 5, 2016 at 6:44 am

#1888441
RE: Procedure fails when called from a job

kevaburg (7/5/2016)
Hi,
The Problem is resolved.
The SQL Agent User had a different language Setting to that in the database. It was resolved by inserting SET LANGUAGE ENGLISH at the start...
--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 5, 2016 at 5:55 am

#1888430
RE: Help creating a dynamic table of numbers

Here's my take on the problem. First, you need a Tally function. Here's my permutation of Itzik Ben-Gan's work. The "zero" thing needs a little work but...
--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 4, 2016 at 11:39 pm

#1888373
RE: not able to find why/where this error is comming.

Sergiy (7/4/2016)
rajemessage 14195 (7/3/2016)
please tel me some key words , show that i will search in my stored prcedure
TRY -- CATCH ?
Or just BEGIN TRANSACTION?
--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 4, 2016 at 8:10 pm

#1888367
RE: Easy piece of code just doesnt bloody work.

Duran (7/4/2016)
Hi Jeff,
If it was just that on its own Id agree, but this is a small cog in a much larger automation scenario.
Regards,
D
What is the "much larger automation scenario"?...
--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 4, 2016 at 6:54 pm

#1888366
RE: CPU Usage 100%

jayoub (7/4/2016)
I looked at the simple talk article by Gail Shaw and it was great. I actually set it up on the test environment and will eventually on production.....
--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 4, 2016 at 6:48 pm

#1888364
RE: Unstructured data sources into a structured DW

leehbi (7/4/2016)
We can create a model that works today but may be broke tomorrow.
The bigger problem is that in the BI domain we're quite far from the App domain, hence...
--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 4, 2016 at 6:39 pm

#1888363
RE: Easy piece of code just doesnt bloody work.

Why anyone would use Posh to do such a trivial thing even across multiple databases is totally beyond me. My recommendation would be to go back to the simplicity...
--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 4, 2016 at 12:30 pm

#1888354
RE: Justify DBA access to production

p.s. The latter option sounds most likely... Your bloody CIO should already know what a bad idea you not having privs on the prod box is. He shouldn't...
--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 4, 2016 at 12:27 pm

#1888353
RE: Justify DBA access to production

Patience is a virtue here. When people ask me what I do as a DBA, I frequently tell them that it's too long to explain but they'll know 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 4, 2016 at 12:24 pm

#1888352

Viewing 15 posts - 17,341 through 17,355 (of 59,102 total)