Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,411 through 16,425 (of 59,067 total)

RE: Risks of Updating to another edition

luismarinaray (11/1/2016)
Hi Friends,
According this documentation,
https://msdn.microsoft.com/es-es/library/ms143393(v=sql.105).aspx
Upgrade path from SQL Server 2005 Enterprise to SQL Server 2008 R2 Standard, is not a
valid path, I have to update to SQL Server 2008 R2...
--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)

November 1, 2016 at 3:58 pm

#1910018
RE: Query to Dynamically Sum Sales Amounts By Month, Quarter, or Year

ptownbro (11/1/2016)
Thanks guys. I learned a lot from reading Jeff's articles. Interestingly I had already developed Sort path method (which I called a Tree Path) as well as incorporated CTE'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)

November 1, 2016 at 2:59 pm

#1910007
RE: Show data upto 2 decimal places but with exact values

drew.allen (11/1/2016)
snowprincess42073 (10/31/2016)
Hi all,
I would like to show the data up to 2 decimal places but without rounding off the integers. If the number is 4.6758 then data retrieved should...
--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)

November 1, 2016 at 2:56 pm

#1910005
RE: Show data upto 2 decimal places but with exact values

snowprincess42073 (10/31/2016)
Hi all,
I would like to show the data up to 2 decimal places but without rounding off the integers. If the number is 4.6758 then data retrieved should 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)

November 1, 2016 at 1:46 pm

#1909996
RE: SQL help - how to write a query with reference to its own results

sanda.jan00 (11/1/2016)
drew.allen (10/31/2016)
sanda.jan00 (10/29/2016)
Thanks a lot from both of you!!!
Now, consider the adjusted table provided by you, could you pls give me some advice how to write my query?? 🙂
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)

November 1, 2016 at 1:34 pm

#1909993
RE: Speeding Up Delete's on Large Databases

ChrisM@Work (11/1/2016)
So we decided to try cache priming - getting the required data into cache with a low-cost read before processing it. A single loop of the code we ran...
--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)

November 1, 2016 at 8:29 am

#1909884
RE: SQL SERVER 2014 Snapshot replication

I don't use SQL Server replication so I can't answer your question but this should serve as another "bump" to your 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)

October 31, 2016 at 9:09 pm

#1909779
RE: What random trash is in your drawer?

Fingers from developers that don't get it yet. 😛
Old AARP cards.
--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 31, 2016 at 9:07 pm

#1909778
RE: insert value comma/ dot issue

kj700098 39683 (10/31/2016)
thanks but I have tried default language = norwegian and no help.
The issue is that that the transact sql see four columns here
VALUES (1, '1 Value', 18,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 31, 2016 at 8:05 pm

#1909775
RE: SENDING DAILY EMAIL ATTACHMENT WITH SQL QUERY TO GIVEN USERS.

philand3 (10/23/2016)
Dear All,
i would like to send out following query to all email users daily basis,can anyone guide me the direction,
it can be from SQL or external tool,ETC.
SELECT ...
--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 31, 2016 at 7:49 pm

#1909774
RE: insert value comma/ dot issue

I'm not totally sure but I believe you'll have to change the language setting. You'd do that with the follow syntax example from Books Online. Make the appropriate...
--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 31, 2016 at 7:03 pm

#1909772
RE: Are the posted questions getting worse?

Wryan138 (10/31/2016)
I think that Jeff was politely saying that the best way to not see the SPAM is to
put ME on the Ignore List. To date 99% of my...
--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 31, 2016 at 6:47 pm

#1909771
RE: Are the posted questions getting worse?

GilaMonster (10/31/2016)
Sean Lange (10/31/2016)
What is this ability to delete spam some of you are talking about? I guess I am not part of that club.
Me neither. Wish I could do...
--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 31, 2016 at 2:47 pm

#1909757
RE: Speeding Up Delete's on Large Databases

Eirikur Eiriksson (10/31/2016)
Jeff Moden (10/31/2016)
Eirikur Eiriksson (10/31/2016)
Quick suggestion, reading the data to be deleted into a "bucket" variables can drastically speed up the delete, here is an example based 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)

October 31, 2016 at 2:37 pm

#1909753
RE: If Query Returns results send a email

Question now is, what the hell happened to my post which included code to do this (or maybe this is a duplicate post)? I'll see if I saved 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 31, 2016 at 10:34 am

#1909693

Viewing 15 posts - 16,411 through 16,425 (of 59,067 total)