Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,651 through 22,665 (of 59,067 total)

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
RE: Table creation policies. Is this silly or is it just me?

Luis Cazares (8/25/2014)
The sad reality is that "very controlled, monitored and process oriented system" is just a nice wish as there are many things that just get into production 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)

October 1, 2014 at 8:41 am

#1749415
RE: Expired SQL 2012 license. Moving on to 2014

Dante Garcia (8/26/2014)
Hello, I'm having an issue with an expired license.
I have a development database in SQL 2012 in which I had been working till the license expired today. I...
--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 7:57 am

#1749400
RE: Problem w/temporary tables in Stored Procedure accessed by SSRS

psullivan (9/14/2004)
remember #temp is going away in favor of the the above..
Heh... I know it's an old post but 10 years have gone by and that hasn't come close 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)

September 30, 2014 at 5:20 pm

#1749285
RE: Why do they not listen?

Eric M Russell (9/30/2014)
GilaMonster (9/30/2014)
Eric M Russell (9/29/2014)
Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.
"I'm so sorry, I know...
--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)

September 30, 2014 at 8:12 am

#1749164
RE: Why do they not listen?

GilaMonster (9/30/2014)
Eric M Russell (9/29/2014)
Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.
"I'm so sorry, I know it a pain...
--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)

September 30, 2014 at 7:41 am

#1749145

Viewing 15 posts - 22,651 through 22,665 (of 59,067 total)