Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,026 through 26,040 (of 59,099 total)

RE: Communicating with Non-Technical Users

I strongly agree with Brandie and Tom. I usually don't try to teach users about databases unless they're actually interested in how things work. What usually works for...
--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)

August 31, 2013 at 9:25 am

#1646571
RE: T-SQL Pvot Data and Hide duplicates

az1862 (8/30/2013)
Thanks a lot I will make sure to post in format you requested next time.
I can help there. Please see the first link in my signature line below...
--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)

August 30, 2013 at 11:44 pm

#1646534
RE: how to write query

amitsingh308 (8/29/2013)
Hello
I have to generate a report in which amount should be 13 digits.
e.g 2000- convert it into paisa 200000 then 13 digit amount is 0000000200000
but I want it 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)

August 30, 2013 at 11:42 pm

#1646533
RE: how to write query

If you're interested in speed, STR isn't the way to do it. And since it does a FLOAT conversion in the process, it can slip into the same approximation...
--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)

August 30, 2013 at 11:34 pm

#1646532
RE: Fastest way to read a 600MB table (in memory)

Heh... you're in IT where there's nothing but jargon. 😉
--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)

August 30, 2013 at 11:25 pm

#1646531
RE: I partitioning ever simple?

Partitioning usually isn't any faster than the right kind of query played against properly designed tables and indexes. Partitioning is to make index management easier, backups smaller, and a...
--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)

August 30, 2013 at 11:17 pm

#1646529
RE: Help

jeetsingh.cs (8/30/2013)
I am DBA with two year of experience on SQL server 2008 R2,
i have some questions that should i stick to this field or switch to BI as a...
--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)

August 30, 2013 at 8:02 am

#1646380
RE: What's next?!

Greg Larsen (8/30/2013)
I'm a little tardy on getting the next stairway out. Hopefully within the next few months you will start seeing articles in my next stairway.
Thanks for 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)

August 30, 2013 at 7:56 am

#1646377
RE: sp_getrecords to get all records from a table

Sean Lange (8/30/2013)
Jeff Moden (8/30/2013)
Heh... all this work just to avoid typing "SELECT * FROM ", which can be a really bad idea in itself depending on the number of...
--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)

August 30, 2013 at 7:55 am

#1646376
RE: sp_getrecords to get all records from a table

Heh... all this work just to avoid typing "SELECT * FROM ", which can be a really bad idea in itself depending on the number of rows in the 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)

August 30, 2013 at 7:41 am

#1646366
RE: Create a stored procedure on multiple databases

Guras (8/30/2013)
SQLSteve (8/30/2013)
Also, if adding the SPs to all databases on your instance, be sure to add them to the model database so you do not have to go through...
--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)

August 30, 2013 at 7:35 am

#1646362
RE: Would like to add data in table when sql m/c starts or shutdown

harsimranjeetsinghwasson (8/30/2013)
:unsure: I guess table to log data should also be created in master only , because when i did so i started logging data.
One thing i would like 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)

August 30, 2013 at 7:20 am

#1646359
RE: Wrong datatype for SP?

SrcName (8/30/2013)
Hi, SSC-Dedicated
Based on your experience,
i would be appreciate if you explain in detail how SQL Injection will pass this.
P.S.
maybe in this case it's no so important, this select statement...
--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)

August 30, 2013 at 7:17 am

#1646354
RE: Dynamic SQL and DATEADD with User Defined Variable in Number/2nd position

churi.hrushikesh (8/30/2013)
Declare all variable used in dynamic query as nvarchar or varchar. It will work for sure.
Better than that, don't use dynamic SQL because it doesn't look like it's even...
--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)

August 30, 2013 at 7:04 am

#1646348
RE: Dynamic SQL and DATEADD with User Defined Variable in Number/2nd position

rebecca 79612 (8/29/2013)
This syntax
SET @sql = 'SELECT * FROM <sometable> WHERE dateadd(hh, ''' + @tzoffset + '''), END_DATETIME) BETWEEN ''' + @StartDate + ''' AND ''' + @EndDate + ''''
returns...
--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)

August 29, 2013 at 10:41 pm

#1646230

Viewing 15 posts - 26,026 through 26,040 (of 59,099 total)