Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,786 through 22,800 (of 59,102 total)

RE: RECEIVE TOP 1000 Not retrieving 1000 messages

venoym (9/2/2014)
By the way, XQuery is tons slower than OPEN~~QUERY~~XML when you need to shred unknown XML elements.
Heh... I knew what you meant and I find that VERY interesting...
--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 13, 2014 at 11:21 am

#1745275
RE: Using COALESCE and also trying to multiply and divide

TomThomson (9/11/2014)
Luis Cazares (9/11/2014)
You should remember the third normal form: "all the attributes in a table are dependent on the primary key and only the primary key."
While I agree with...
--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 13, 2014 at 11:05 am

#1745271
RE: Using COALESCE and also trying to multiply and divide

Post removed.
--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 13, 2014 at 10:36 am

#1745267
RE: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

elham_azizi_62 (9/13/2014)
hello all.
I have one table with a image type field.when I select a row from this table I get error:
A transport-level error has occurred when receiving results from 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 13, 2014 at 10:33 am

#1745266
RE: Made it to Ten Centuries!

Well done! Great morning routiine, BTW. 🙂
--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 13, 2014 at 7:16 am

#1745249
RE: swap tables

This sounds an aweful lot like an interview question.
--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 12, 2014 at 4:29 pm

#1745213
RE: Splitting Strings Based on Patterns

fregatepllada (9/12/2014)
Dwain you do not need CLR to use regex 🙂
There is an old way to call Vbscript library
From t-SQL code 😉
sp_OA???
--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 12, 2014 at 4:11 pm

#1745212
RE: Week Start and End by Month

mark.stewart 12691 (9/12/2014)
Jeff,
Thanks so much for the help! That worked perfectly. I'll dig in and understand dates a little better.
Mark
Very cool. 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)

September 12, 2014 at 1:33 pm

#1745188
RE: Week Start and End by Month

The following should do it (see attached). I made sure that it's a high performance iTVF instead of an mTVF. I also got rid of the resource hungry,...
--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 12, 2014 at 11:00 am

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

G-Force (9/12/2014)
Hi I am receiving 1 csv file daily. The schema is static and the same for each file. I have created a table with the same schema as 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 12, 2014 at 9:11 am

#1745122
RE: Week Start and End by Month

What are the rules for the partial weeks at the start and the end of each month?
--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 11, 2014 at 11:52 am

#1744890
RE: Need Help for my Query

maroju1 (9/11/2014)
Hi All,
This is Naveen Maroju,I unable to get output and please help me on this query.
Mainly i want groupby Vendorname cloumn for below points.
1) If he select Month then...
--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 11, 2014 at 8:49 am

#1744810
RE: Need help for complex query

And are you actually using SQL Server 2012? I ask because LEAD/LAG wasn't available until then and LEAD/LAG is the supported method for doing this. If not, then...
--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 11, 2014 at 8:42 am

#1744804
RE: Generate Triggers for Newly created tables

vijay.singh 14112 (9/11/2014)
Hi All,
I have many new tables for which i need to write Insert,Update and delete triggers manually. Is there any way to generate triggers script which takes 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)

September 11, 2014 at 8:38 am

#1744801
RE: Practical Uses for Synonyms in SQL Server

waldodj2000 (9/11/2014)
What you think about synonyms vs views?
In a view i do: SELECT * FROM server.db.dbo.table
and then I use SELECT * FROM myVIEW
In a Synonyms i do the same.
what...
--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 11, 2014 at 8:30 am

#1744794

Viewing 15 posts - 22,786 through 22,800 (of 59,102 total)