Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,681 through 22,695 (of 59,102 total)

RE: Login Trigger Causing Deadlocks

Ok.... I've studied your code and tables a bit. Let's peel one potato at a time...
First, I see no need for the explicit transaction. Getting rid of 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)

October 3, 2014 at 12:24 am

#1749872
RE: Login Trigger Causing Deadlocks

Stamey (10/2/2014)
Jeff,
In a perfect world this never would have happened. In my world, ruled by management, I can only be as heavy-handed as they will allow me. My first suggestion...
--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)

October 2, 2014 at 10:45 pm

#1749870
RE: Remove non alpha chars from a column

dwain.c (10/2/2014)
DonlSimpson (10/2/2014)
Maybe I'm missing something here, but this is simple and fast:
declare @t varchar(5000) = 'RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row." This-divided-by,that|&/multiplied\by(100)give*you,%;<percent>.'
declare @s-2...
--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)

October 2, 2014 at 10:37 pm

#1749869
RE: Table creation policies. Is this silly or is it just me?

Thanks for the feedback, Tom. And, yeah... I wish more managers "got 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)

October 2, 2014 at 10:28 pm

#1749868
RE: db_owner or not

You bet. Thank you for the feedback. They should be able to do everything they need to with those privs.
--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)

October 2, 2014 at 9:55 am

#1749726
RE: Help avoiding temp table with string of IDs passed into stored procedure

For passing large numbers of ID's, you might want to consider passing them as XML with some short tags so that you can pass more than 8K worth of ID's....
--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)

October 2, 2014 at 9:50 am

#1749723
RE: Help avoiding temp table with string of IDs passed into stored procedure

Heh... have you done an actual test to see which is better? You have to remember that even supposed "actual" excution plans are estimates in many ways.
Execution plans help...
--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)

October 2, 2014 at 8:53 am

#1749702
RE: default schema of windows group user

sqlfriends (10/1/2014)
I am using SQL server 2012.
An user tried to export tables from GIS application to the SQL database.
After export, and login to the SQL server, we see all 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)

October 2, 2014 at 8:23 am

#1749694
RE: BULK INSERT from variable Date Filename - ERROR

You've used double quotes in places where there should be single quotes.
Provided that @dt has been sufficiently scrubbed for SQL Injection, the following should work and requires a...
--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)

October 2, 2014 at 8:05 am

#1749686
RE: db_owner or not

Koen Verbeeck (10/2/2014)
sqlfriends (10/1/2014)
No, they donot need to.
They just need to create tables, views, procedures.
and Import/export tables.
Thanks,
This sounds like DDL_admin, read/write/execute permissions to me.
That sounds right to me. ...
--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)

October 2, 2014 at 7:51 am

#1749683
RE: Are the posted questions getting worse?

SQLRNNR (10/1/2014)
Steve Jones - SSC Editor (10/1/2014)
Congrats, Jack and Jason. Well deserved and earned.
Thanks Steve
Long time coming, Jason. Congratulations. Same to Jack for his renewal. Well done.
--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)

October 2, 2014 at 7:46 am

#1749681
RE: Login Trigger Causing Deadlocks

Stamey (10/2/2014)
We are trying to track and get these elevated IDs out of the hands of those who should not have them.
Gosh, this sounds like it's really out of hand...
--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)

October 2, 2014 at 7:27 am

#1749675
RE: Change rowns to columns

Please see the following article. I know you don't want an aggregate but it's one of the few ways that you can privot data in SQL Server. 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)

October 2, 2014 at 7:19 am

#1749674
RE: Remove non alpha chars from a column

Ah... my apologies. I had to withdraw my post that was in this spot. At first, it looked like your CROSS APPLY "GetNums" was twice as fast as...
--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)

October 1, 2014 at 10:56 pm

#1749584
RE: Remove non alpha chars from a column

bgalway (9/30/2014)
Not sure if this query extract is helpful but it helped me in a recent situation where I was trying to deal with non-alpha characters:
WHERE ([Bill Freq] IS...
--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)

October 1, 2014 at 5:20 pm

#1749573

Viewing 15 posts - 22,681 through 22,695 (of 59,102 total)