Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,846 through 31,860 (of 59,099 total)

RE: Little Love Lost for SMO

BWAA-HAAA!!! I love it. Powershell... deprecation warning. Yeah... let me run out an learn how to use that!:-P
The more things change, the more they stay the same. ...
--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 27, 2011 at 9:22 am

#1413187
RE: New faster server much slower than old slow server?

Gosh, there are a thousand reasons why this might be so... anywhere from someone changing the FILLFACTOR on the Clustered Index to having an improperly configured or less capable disk...
--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 27, 2011 at 9:14 am

#1413185
RE: Create a new column that concatenates a phrase with an integer

mahdib21 (11/26/2011)
The "AS" phrase is producing an error :/?
First, post the code that you're actually having a problem with. Lots of folks make a mistake when copying code.
Second, are...
--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 27, 2011 at 9:01 am

#1413183
RE: Get Dates of Month listed as Columns

vani_r14 (11/26/2011)
Hi all
I am trying to come up with a Script that lists the dates individually in each month in a column format.
Currently i have written a function...
--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 27, 2011 at 8:57 am

#1413182
RE: delete duplicate record

AmitAgrawal (11/25/2011)
Hi,
You can try below solution
delete T1
from MyTable T1, MyTable T2
where T1.dupField = T2.dupField
and T1.uniqueField > T2.uniqueField
Finally... a different idea than the rest. However, that uses a Triangular Join....
--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 27, 2011 at 8:49 am

#1413181
RE: delete duplicate record

dastagiri16 (11/27/2011)
delete from talbe where id not in (select max(column_id) from talbe group by column_name)
Except for the missing columns, that's identical to the original problem-code. 😉
--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 27, 2011 at 8:45 am

#1413180
RE: delete duplicate record

Cadavre (11/25/2011)
Since this post seems to not want to die, here's an update of the test script I posted before to include the unique solutions posted since.
Heh... apparently reading previous...
--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 27, 2011 at 8:42 am

#1413179
RE: Adding a column alias to be the field name in a new table

It's the same as any other alias... either of the following methods work just fine...
SELECT SD_SalesOrderID = SD.SalesOrderID,
SH_SalesOrderID = SH.SalesOrderID
...
--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 27, 2011 at 8:34 am

#1413177
RE: table performance

znkin (11/27/2011)
I have a transactions table created in my Sql 2008 database which stores data entered by users from my web application. I have also provided a page in 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)

November 27, 2011 at 8:16 am

#1413175
RE: table performance

viiki.seth (11/27/2011)
Try query hint with nolock on your search query. so that no shared locks are issued against the table that would prohibit other transactions from modifying the data...
--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 27, 2011 at 7:50 am

#1413172
RE: Need to format HH:MM:SS

I'll have to leave it to one of the others, thenm Robin. SSRS isn't my strong suite.
--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 26, 2011 at 8:49 am

#1413115
RE: Why does the same code yield different results running in T-SQL interactively vs. as a TVF?

rmechaber (11/24/2011)
P.S. Your initial reply referenced a 'Jeff Moden book on "High Velocity Porkchop Launchers"', yet I saw no link to this Amazon bestseller. Care to explain where we...
--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 26, 2011 at 8:36 am

#1413114
RE: Are the posted questions getting worse?

Jack Corbett (11/24/2011)
It's Thanksgiving Day here in the U.S., so Happy Thanksgiving to everyone who celebrates, and if you don't happy Thanksgiving to you anyway:-P.
I'm very thankful for the friendships...
--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 26, 2011 at 8:31 am

#1413113
RE: How to store lots of data (1024 columns) for a particular reading

loki1049 (11/25/2011)
So we I have tried to split the string, which will be in the form of "X.XXEXX,X.XXEXX,X.XXEXX," but using the split function like say the DelimitedSplit8k will not work...
--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 26, 2011 at 8:20 am

#1413112
RE: Need to format HH:MM:SS

robin 31791 (11/25/2011)
This is great! Just what I've been looking for! One small question - how would I make it pad with a zero for any of 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)

November 26, 2011 at 8:07 am

#1413110

Viewing 15 posts - 31,846 through 31,860 (of 59,099 total)