Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,311 through 17,325 (of 59,067 total)

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
RE: Rename file - prefix with file date

jeffe_verde (7/4/2016)
Thank you both for the excellent suggestions. I ended up configuring a ForEach Loop container to enumerate by file date, as described in this article.
For those that...
--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:46 am

#1888350
RE: Rename file - prefix with file date

Phil Parkin (6/28/2016)
Jeff Moden (6/27/2016)
jeffe_verde (6/26/2016)
The files have data for the Asia-Pacific, EU, and the Americas financial markets (thus the AP, EU, and AM in the file names), and each...
--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:43 am

#1888349
RE: Improvements in SQL Server Environment

rkrpat (6/29/2016)
Hi All,
This is general question and not any Technical one.
Our SQL Server environment is stable and we are being chased for Service Improvements.
Could you please suggest any improvements that...
--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 3, 2016 at 11:05 pm

#1888244
RE: Global change with powershell for sql

mario17 (6/27/2016)
Hi,
I need to make global change in source code for sp for 200+ procedures, I did some python script for this, but now we decided that we need 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)

July 3, 2016 at 11:02 pm

#1888243
RE: Continuous Blocking

ramana3327 (6/21/2016)
Hi Experts,
We are receiving continuous alerts about the alers. One of the insert statement is the main blockger.
I didn't get the permission to kill that spid
Do I need 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)

July 3, 2016 at 10:58 pm

#1888242

Viewing 15 posts - 17,311 through 17,325 (of 59,067 total)