Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,141 through 31,155 (of 59,101 total)

RE: Order by While inserting

Koen Verbeeck (2/14/2012)
ID is an identity column, you shouldn't try to force it into a specific order.
Furthermore, it is useless to specify an ORDER BY on an INSERT.
ORDER BY Clause...
--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)

February 14, 2012 at 10:19 am

#1446955
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (2/14/2012)
Steve Jones - SSC Editor (2/14/2012)
Jeff Moden (2/13/2012)
Shifting gears, I was going through the posts from "Posts added today" and there had to be two...
--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)

February 14, 2012 at 9:51 am

#1446938
RE: granting execute privilege on all stored procs in a database to a user

SQLKnowItAll (2/14/2012)
Jeff Moden (2/13/2012)
SQLKnowItAll (2/13/2012)
USE databaseName
GRANT EXEC ON SCHEMA::dbo TO userName
That should do the trick, assuming the schema for these objects is dbo! Else, replace dbo with the schema 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)

February 14, 2012 at 9:20 am

#1446915
RE: SQL query datetime theory question

pharmboy4u (2/14/2012)
Hello,
I have a query that's pretty bulky due to dates only, and I'm sure there's a better way. It resembles this:
select * from
(select a
from 1
join 2
where bla...
--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)

February 14, 2012 at 6:27 am

#1446811
RE: Mulitple Saarch Criteria using ONE Column

Cadavre (2/14/2012)
Am I missing something?
SELECT Code, Name, City
FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY City ORDER BY Code) AS rn
FROM #MyHead
...
--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)

February 14, 2012 at 6:19 am

#1446804
RE: Optimize speed of maintenance tasks

mchofman (2/14/2012)
Jeff,
the solution you suggest is a possibility for application I (or my company) have created. This application (MDW) is created by Microsoft, so it refers to the table name...
--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)

February 14, 2012 at 6:17 am

#1446801
RE: DBCC REINDEX on table with 970GB data and 10GB index with 5 billions rows of count

george sibbald (2/14/2012)
I'm surprised Gail and Jeff haven't jumped all over this but that does not look like a good candidate for a clustered index, its certainly not narrow or...
--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)

February 14, 2012 at 6:13 am

#1446799
RE: sp_send_dbmail

You could always use CDOSYS instead.
--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)

February 13, 2012 at 11:48 pm

#1446641
RE: Count Function

ChrisM@home (1/18/2012)
jennigirl (1/18/2012)
I was able to get the query results I need, but I am looking to now present the results as the total count of trouble tickets assigned 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)

February 13, 2012 at 11:46 pm

#1446640
RE: Combining Simple Count Queries

Heh... I map dark rooms with a flame thrower. Keeps me from pricking my finger on a needle. 😛
--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)

February 13, 2012 at 11:42 pm

#1446639
RE: Please help with this query. This is very challenging.

Mark-101232 (2/8/2012)
WITH CTE AS (
SELECT part, stat, datevalue,
ROW_NUMBER() OVER(PARTITION BY part ORDER BY datevalue) AS rn
FROM dbo.test_table)
SELECT z.part,z.stat,z.datevalue,n.stat,n.datevalue
FROM CTE z
INNER JOIN CTE n...
--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)

February 13, 2012 at 11:32 pm

#1446638
RE: Please help on Logic

Actually, this is all very easy using BULK INSERT which now allows you to do like we used to do in BCP. Sequester errors in a file and keep...
--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)

February 13, 2012 at 11:27 pm

#1446637
RE: Please help on Logic

xRafo (2/9/2012)
Hmm, can u prove it?, i mean,
do you have an example and probe it what you say?
It's a well known fact. Google it. 😉
--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)

February 13, 2012 at 11:24 pm

#1446636
RE: Column Retrive using column id

I guess my only question would be... why are you doing this by column number instead of by column name?
--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)

February 13, 2012 at 11:05 pm

#1446635
RE: Please fix the "Pretty Print" class in the forums and the article "Contribution Center"

Man! I've got to say it again! Hat's off to the SSC Dev Team for fixing the code window length problem and the code window copy problem! ...
--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)

February 13, 2012 at 10:31 pm

#1446632

Viewing 15 posts - 31,141 through 31,155 (of 59,101 total)