Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,891 through 31,905 (of 59,099 total)

RE: Decimal Number format as String

Multiply QUANTITY in Ron's answer by 100000 first, convert it to an INT, and then apply Ron's answer.
--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 22, 2011 at 10:19 pm

#1411941
RE: Dealing with Incomplete Data - A T-SQL Puzzle 1

Suresh Kumar Maganti (11/22/2011)
The Query cost (relative to the batch) was 17% for the one in the article. The same for the alternative version was 83%.
The query cost relative...
--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 22, 2011 at 10:07 pm

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

opc.three (11/22/2011)
Max of a comma-delimited string can be found quite easily in .NET using "Split" to create an Array from a comma-delimited list
Precisely my point. And it would 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 22, 2011 at 9:41 pm

#1411932
RE: Recover deleted records

mimran18 (11/22/2011)
This articale can help you to recover the deleted data from sql server 2005 and above.
http://raresql.com/2011/10/22/how-to-recover-deleted-data-from-sql-sever/
Absolutely incredible, Muhammad. I'm definitely going to dig into that. I didn't...
--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 22, 2011 at 6:24 am

#1411417
RE: missing records on table

Now THAT I agree with. It is a bit of an oolie.
--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 22, 2011 at 6:16 am

#1411403
RE: missing records on table

Yes. Between those types of indexes and triggers, people can get quite confused when things don't operate as expected simply because they're "hidden" functionality. I believe the interviewer...
--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 21, 2011 at 9:51 pm

#1411193
RE: Data Rollup

Vinay ,
Would you post the CREATE TABLE statement for the columns you posted for the table your data is in please? I need to know what all 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 21, 2011 at 9:37 pm

#1411192
RE: Data Rollup

You're welcome for the test data. Unfortunately, that wonderful bit of XML prestidigitation doesn't consider the data from the previous month like the OP wanted. There 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 21, 2011 at 9:27 pm

#1411190
RE: Faster way to INSERT INTO large table

Evil Kraig F (11/21/2011)
Amy.G (11/21/2011)
I would sincerely look into 2-staging this process however. Holding insert/exclusive locks on the Alvis_22 schema table until this completes is just bad form. ...
--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 21, 2011 at 9:15 pm

#1411186
RE: SELECT inside a FROM - bad programmming practice?

bomborde (11/21/2011)
An order will be inefficient because it will order the whole table. I dont want this. (imagine a table with 500k tuples). I just want the maximum.
Nope... not true....
--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 21, 2011 at 8:55 pm

#1411181
RE: advice on archiving data

Evil Kraig F (11/21/2011)
Any SQL services or tools to aid in this?
Not really.
What about table partitioning or even partitioned views?
--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 21, 2011 at 8:44 pm

#1411177
RE: More SQL Injection

From the Article:
There's no excuse for companies not making a complete review of older code and updating it to avoid unvalidated input or passing through queries that could 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 21, 2011 at 8:39 pm

#1411176
RE: More SQL Injection

niall.baird (11/21/2011)
it isn't a stored procedure, it's inline dynamically generated SQL.
But wouldn't they be using sp_executesql if they're using ~~polished dog-turds~~ dynamically generated sql?
Heh... every one knows you can't...
--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 21, 2011 at 8:36 pm

#1411175
RE: I have a coworker....

Tom Brown (11/21/2011)
Sean Lange (11/21/2011)
Of course if you don't want to spend the money for pressurized cookware you can just add salt. Pressure and salinity will increase the boiling...
--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 21, 2011 at 8:07 pm

#1411171
RE: I have a coworker....

MysteryJimbo (11/21/2011)
aka a pressure cooker. HTH 😀
BWAAA-HAAA!!! And here I thought that was a job description! 😛
--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 21, 2011 at 8:03 pm

#1411170

Viewing 15 posts - 31,891 through 31,905 (of 59,099 total)