Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,756 through 22,770 (of 59,102 total)

RE: Are the posted questions getting worse?

SQLRNNR (9/17/2014)
Ahhh but SQL 2014 does come with a turbo button.:w00t:
BWAAA-HAAAAA!!!!! SQL Server has always had that "button". Just set "Boost SQL Server Priority" setting to "ON" so 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)

September 17, 2014 at 7:12 pm

#1746247
RE: Are the posted questions getting worse?

Roy Ernest (9/17/2014)
I advised the OP to go for Set based. I hope he does not think that SQL 2014 will magically get everything to run faster.
Oddly enough, 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)

September 17, 2014 at 7:07 pm

#1746246
RE: Release a large amount of free space from a data file.

Welsh Corgi (9/17/2014)
I'm not concerned that it may grow at the same rate.
I am concerned that it happened.
I want to re-index and I thought that it would not hurt 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 17, 2014 at 7:04 pm

#1746244
RE: Release a large amount of free space from a data file.

Welsh Corgi (9/17/2014)
I have a Database that is currently 642 GB is size with 317 GB free (49%).
I do not know how it got so large but what would be...
--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 17, 2014 at 7:00 pm

#1746243
RE: Are the posted questions getting worse?

Roy Ernest (9/17/2014)
I got someone asking if Cursor will work fast on memory based objects.
It felt like the OP would upgrade to SQL 2014 so that he/she can make...
--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 17, 2014 at 6:53 pm

#1746240
RE: Week Start and End by Month

hmbtx (9/17/2014)
Jeff:
Thank you for your reply.
I just tried it again and I am not leaving out any characters.
I get the same error.
I am running it SQL Server 2008R2.
Thanks
Howard
Apologies on this,...
--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 17, 2014 at 6:16 pm

#1746238
RE: sp_send_cdosysmail Vs sp_send_dbmail

OK... no answer to my question. I'll summarize just by saying that sp_Send_DBMail is support and CDOSYS is no longer supported. That, not withstanding, I almost always use...
--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 17, 2014 at 3:21 pm

#1746229
RE: ERROR CREATING PROXY ACCOUNT....

Hi Jorge,
Did you ever get an answer from anywhere for this problem? If so, how did you solve it? Thanks.
--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 17, 2014 at 3:09 pm

#1746225
RE: Are the posted questions getting worse?

Luis Cazares (9/17/2014)
Do I see some personal/professional growth in these words? I really hope so.
This Post is closed. I will research the issue.
Thanks.
Out of context, it looks more like 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)

September 17, 2014 at 12:49 pm

#1746195
RE: Week Start and End by Month

hmbtx (9/17/2014)
When I ran the following example for FUNCTION dbo.GetWeeksForMonth
--===== Return weeks in current month
SELECT WeekNo, WeekStart, WeekEnd, DaysInWeek
FROM dbo.GetWeeksForMonth(GETDATE())
I got the following error
Msg 102,...
--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 17, 2014 at 12:46 pm

#1746194
RE: Daily CSV import to SQL - How ?

P Jones (9/17/2014)
...and wait until it is fully available ....
I'm curious. What are you using to determine that a file is done being written to and is ready 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)

September 17, 2014 at 8:33 am

#1746087
RE: Query AD - Script Out of memory

Gary Varga (9/16/2014)
Jeff Moden (9/16/2014)
T2000 (9/11/2014)
... but the script stops after some time, "Exception of type 'System.OutOfMemoryException' was thrown".
I'm curious... what kind of system did you run this 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)

September 16, 2014 at 10:59 am

#1745840
RE: Checking sequence of codes

richardmgreen1 (9/16/2014)
Thanks Matt
That looks to have done the trick.
I'll have to double-check but it looks good at first pass.
I'll second Matt's solution over splitting the data. Even if you...
--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 16, 2014 at 10:55 am

#1745839
RE: Daily CSV import to SQL - How ?

G-Force (9/16/2014)
Hi Jeff
Still trying to find the dummies guide 🙂 . Is there anywhere you can point me to on how to do it in TSQL ?
Any help gratefully received.
Thanks
G
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)

September 16, 2014 at 10:53 am

#1745838
RE: compare the next row with the previous row of same table

abhas (9/16/2014)
Hi bros,
I need to compare the next row with the previous row of same table and produce nonidentical column.
for eg... say
mytable has
Row 1 => 1001 Abhas 120 150...
--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 16, 2014 at 8:40 am

#1745805

Viewing 15 posts - 22,756 through 22,770 (of 59,102 total)