Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,336 through 25,350 (of 59,099 total)

RE: Core T-SQL

ojrodriguez (11/22/2013)
I think that a basic level of proficiency should include implementing structured and unstructured error handling.
About the apply and the windowing functions, or OVER CLAUSES as some developers call...
--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)

November 22, 2013 at 7:04 pm

#1668575
RE: Pushing inserts into SQL server with C# ?

blasto_max (11/22/2013)
Jeff Moden (11/21/2013)
I solved a similar problem before. Some developers for a 3rd party developed front end code that passed 250,000 individual inserts as part of an "initialization"...
--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)

November 22, 2013 at 6:10 pm

#1668571
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Sorry, Elliott. I absolutely agree in most cases and didn't mean to make it sound contrary to what you said. Rather, my intent was to support your position on...
--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)

November 22, 2013 at 5:00 pm

#1668566
RE: Still cannot figure passing a variable to procedure

homebrew01 (11/22/2013)
Can you explain the risk a bit more ?
Yes. Any dynamic SQL that makes use of concatenation or simple replacement of the parameters is subject to a hack...
--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)

November 22, 2013 at 4:47 pm

#1668562
RE: Are the posted questions getting worse?

I'm, very thankfully, not currently in a postition like Lynn where I need to find a job because I wouldn't even consider working for a company like that. 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)

November 22, 2013 at 4:06 pm

#1668557
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Elliott Whitlow (11/22/2013)
If you are going to allow it to call arbitrary EXE files then it isn't. However, I had a project about 4 years ago where we had 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)

November 22, 2013 at 3:45 pm

#1668556
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

thierry.vandurme (11/22/2013)
This is a re-published article and the last replies date back from 2012 but I'll throw my remark in anyway.
CLR is all nice but I still think it's not...
--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)

November 22, 2013 at 3:38 pm

#1668553
RE: Core T-SQL

From the article:
This week I'm curious if we can debate about, and compile, a list of core skills with T-SQL that we think someone ought to understand to be considered...
--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)

November 22, 2013 at 2:35 pm

#1668543
RE: Cursor fetch loops endlessly

David Burrows (11/21/2013)
Jeff Moden (11/19/2013)
I used to be a great VB6 programmer
WHAT :exclamationmark: Are you a bad VB6 programmer now
And after everything you said about CLR sheesh :rolleyes:
p.s. Only joking...
--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)

November 22, 2013 at 1:41 pm

#1668529
RE: Still cannot figure passing a variable to procedure

@Oracle765,
Let's try to science this out in a safer manner. What will you pass in the @Installations variable?
--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)

November 21, 2013 at 11:45 pm

#1668303
RE: Still cannot figure passing a variable to procedure

Oracle765 (11/21/2013)
thanks again grasshopper
I have done that and it works perfect
your a star much appreciated
DO NOT IMPLEMENT THAT DYNAMIC CODE! It probably doesn't need to be dynamic SQL 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)

November 21, 2013 at 11:26 pm

#1668301
RE: Still cannot figure passing a variable to procedure

burfos (11/21/2013)
You need to concat your variable in to your string...
ALTER procedure [dbo].[totalinstallations]
@installations nvarchar(1000)
AS
BEGIN
declare @sql nvarchar(1000)
SET @sql = 'SELECT softwaremanufacturer,productname,productversion,
sum(distinct case when isnumeric(' + @installations + ')=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)

November 21, 2013 at 11:25 pm

#1668300
RE: Pushing inserts into SQL server with C# ?

I solved a similar problem before. Some developers for a 3rd party developed front end code that passed 250,000 individual inserts as part of an "initialization" for a new...
--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)

November 21, 2013 at 8:44 pm

#1668289
RE: Insert Trigger and @@rowcount problem - Performance Issue

jcb (11/19/2013)
Question: a select count(1) from inserted ill return the number of inserted rows?
just for the record: avoid triggers, they are evil.
avoid to put business logic in the database, let...
--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)

November 21, 2013 at 8:16 pm

#1668287
RE: Space did not gets released after removing data

SQLAli (11/21/2013)
Hi,
We have deleted 120GB of data but space did not released even after 2 days. Is there any reason for this? Could any one tell me how exactly it...
--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)

November 21, 2013 at 8:08 pm

#1668286

Viewing 15 posts - 25,336 through 25,350 (of 59,099 total)