Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,811 through 27,825 (of 59,101 total)

RE: ORDER BY Should be same as my input in IN()

CELKO (12/19/2012)
- Written more than three cursors in my lifetime
Five cursors, but you have to be old enough to not have had DRI actions.
- Used UPDATE...FROM...
--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)

December 19, 2012 at 8:00 pm

#1570370
RE: Unwanted parameter truncation

pdanes (12/19/2012)
Jeff Moden (12/19/2012)
There's also a disadvantage to using (for example) VARCHAR(MAX). The MAX datatypes really don't like to be joined to and it will slow down queries.
So I've...
--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)

December 19, 2012 at 11:56 am

#1570247
RE: Reorganize Index

zi (12/19/2012)
Dear Friends
I have made a maintenance plan to reorganize index daily, but this error showed to me and I don't understand it and how to fix 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)

December 19, 2012 at 11:34 am

#1570239
RE: Unwanted parameter truncation

MyDoggieJessie (12/19/2012)
@myself - ID10T error, of course! 8000 is the limit
Nah... no problem. I've made a similar mistake when I had a NEC (Not Enough Coffee) 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)

December 19, 2012 at 11:29 am

#1570237
RE: Unwanted parameter truncation

MyDoggieJessie (12/19/2012)
I don't believe there's a way within SQL to prohibit the truncation of the strings when it's assigned to the variable. How is this proc called? If...
--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)

December 19, 2012 at 11:10 am

#1570229
RE: Passing a parameter as a filename

arnipetursson (12/18/2012)
Are you comfortable with the security issues related with using xp_cmdshell?
There are no security issues related with using xp_CmdShell if your system has the proper security of no one...
--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)

December 18, 2012 at 11:24 pm

#1569900
RE: Using the IN operator with two variable

mozturk 92000 (12/18/2012)
(It's HQL which is similar to T-SQL)
How can I fix my problem ?
Write it as a stored procedure in T-SQL instead of relying on HQL. 😉
--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)

December 18, 2012 at 11:10 pm

#1569891
RE: query to get the name of a product with only incremental values in the quantity column

Nisean (12/12/2012)
i need a query to get the names of the product which has incremental or equal values every year 2009-2012(in its QTY column)
Product ...
--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)

December 18, 2012 at 11:07 pm

#1569889
RE: query to get the name of a product with only incremental values in the quantity column

Nisean (12/18/2012)
thank you for the response. FYI this is not a homework or an interview question. i know how to create a table and insert data on it! i need...
--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)

December 18, 2012 at 10:03 pm

#1569873
RE: query to get the name of a product with only incremental values in the quantity column

CELKO (12/18/2012)
Let's use {snip} and the MySQL year format:
Since this is an SQL Server forum, let's not. Besides, that break a cardinal rule... though shalt not store...
--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)

December 18, 2012 at 9:50 pm

#1569870
RE: Database Diagrams tool in SQLSERVER

mpradeep23 (12/14/2012)
Is thier any other tools before creation of the tables logical diagram
Heh... cocktail napkins and beer coasters!
--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)

December 18, 2012 at 9:41 pm

#1569869
RE: Backup script very slow

RVO (12/18/2012)
I have 5 GB database.
My backup script runs 2 min if I save the file on C drive.
If I run it to save on "\\ networkmachine\bak" it is extremely...
--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)

December 18, 2012 at 9:38 pm

#1569868
RE: Dynamic query

toddasd (12/18/2012)
Of course, I'd do this task like below. Be warned though, that I don't have to worry about sql injection in my closed environment.
Famous last words. 😉
You 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)

December 18, 2012 at 9:29 pm

#1569861
RE: HOW TO TABLE DATA VALUE CHANGES MANUALLY DONE BY A PERSON

If you have not such tracking in place, then how do you know this person in IT changed his attendance records? If you can actually prove it, the charge...
--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)

December 18, 2012 at 9:25 pm

#1569857
RE: Slow Week

I sped a good portion of my time helping others with their problems, etc. I can't wait for it to "get slow" so I can get some 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)

December 18, 2012 at 9:20 pm

#1569854

Viewing 15 posts - 27,811 through 27,825 (of 59,101 total)