Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,126 through 10,140 (of 59,093 total)

RE: Translate Sql Query to Clr

meryemkurs072 - Sunday, January 6, 2019 12:38 PM
Thank you Jeff
Is there an application that translates the following code
CREATE ASSEMBLY [Database8]
...
--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)

January 6, 2019 at 2:54 pm

#2018105
RE: how to do this join?

drew.allen - Friday, January 4, 2019 9:22 AM
Jeff Moden - Thursday, January 3, 2019 8:22 PM
--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)

January 6, 2019 at 2:51 pm

#2018104
RE: Query

pietlinden - Friday, January 4, 2019 9:28 PM
Oh wow... MUCH more readable!
And no Temp Table. 😀
--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)

January 6, 2019 at 2:34 pm

#2018103
RE: Update stats

p.s. What code are you using to identify when the stats need to be rebuilt and what is the code that you're using to do the actual rebuilds? By 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)

January 6, 2019 at 2:24 pm

#2018102
RE: Update stats

RGP - Saturday, January 5, 2019 8:56 PM
Question: in my production server I had noticed the update stats job was failing 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)

January 6, 2019 at 2:13 pm

#2018101
RE: Trigger not working properly

saum70 - Saturday, January 5, 2019 9:36 PM
Hi.
I have a table A in which datq gets inserred through stored procedure. I also...
--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)

January 6, 2019 at 1:53 pm

#2018100
RE: Build a db server just for reporting purpose

Above all else, one solid truth of the matter is that you're standing up a PRODUCTION server. That means licensing fees for both Windows and SQL Server.
--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)

January 6, 2019 at 1:52 pm

#2018099
RE: Translate Sql Query to Clr

meryemkurs072 - Sunday, January 6, 2019 12:16 PM
Thank you for your attention.
I want to translate query security to sqlclr.
I need this c...
--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)

January 6, 2019 at 12:26 pm

#2018096
RE: Does Stored Proc Complete if Machine Rebooted?

tinausa - Sunday, January 6, 2019 8:46 AM
Thanks Jeff, but the code is being transitioned to something bigger nad better so no...
--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)

January 6, 2019 at 9:52 am

#2018088
RE: Log file and data file growth

NP. Thanks for the feedback.
--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)

January 5, 2019 at 4:07 pm

#2018079
RE: Lack of Memory

ZZartin - Friday, January 4, 2019 10:16 AM
robert.sterbal 56890 - Friday, January 4, 2019 8:44 AM
--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)

January 5, 2019 at 2:12 pm

#2018076
RE: SSIS Help!

Heh... doesn't matter. Real Excel file or Excel converted to CSV... you'll have the same problems because the problem isn't in the file type. Unless the Excel file is laid...
--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)

January 5, 2019 at 1:48 pm

#2018075
RE: UTF-8 Requirement for DB - will it work with SQL2014

krypto69 - Friday, January 4, 2019 6:06 AM
HI,
My sys admin sends me an email asking me to install a new DB....
--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)

January 5, 2019 at 12:56 pm

#2018074
RE: Log file and data file growth

Tac11 - Thursday, January 3, 2019 11:56 AM
Hi Gurus,
Is there anyway to query to see if log or/and data file growing 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)

January 5, 2019 at 12:53 pm

#2018073
RE: SQL Memory & Tempdb usage

sqlguy7777 - Saturday, January 5, 2019 2:36 AM
HiI agree with you completely, but weâ€™re kind of stuck with it. The top brass...
--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)

January 5, 2019 at 10:55 am

#2018071

Viewing 15 posts - 10,126 through 10,140 (of 59,093 total)