Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,876 through 25,890 (of 59,102 total)

RE: Search Using Stored Procedure

Probably the biggest thing wrong with it is that it's very prone to SQL Injection. Please see the following article for how to do "Catch All" queries without 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)

September 22, 2013 at 11:23 pm

#1652238
RE: TempDB best practices - Doubt

LOVER OF SQL (9/22/2013)
yes, but the problem at the moment is because my tempdb is thin.... small.. (that is new project - SQL Server)... Hardware, OS, Database... and my tempdb...
--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)

September 22, 2013 at 11:19 pm

#1652237
RE: TempDB best practices - Doubt

LOVER OF SQL (9/22/2013)
and about the size of them? how can i calculate that?
To be honest, I thought my post might inspire you to hit Google so that you can...
--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)

September 22, 2013 at 5:38 pm

#1652225
RE: Build menu with CTE ....

NM.
--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)

September 22, 2013 at 5:22 pm

#1652224
RE: For Each Loop Uploads the Same File Infinitely

Thanks, Vikash.
--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)

September 22, 2013 at 1:12 pm

#1652204
RE: TempDB best practices - Doubt

Double post. No replies here. Please post any answers at the following so we don't split up the answers. Thanks.
http://www.sqlservercentral.com/Forums/Topic1496996-8-1.aspx
--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)

September 22, 2013 at 12:13 pm

#1652201
RE: TempDB best practices - Doubt

LOVER OF SQL (9/22/2013)
someone to volunteer?
Sure. Please see the following links.
https://www.google.com/#q=paul+randal+number+of+tempdb+files
http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/
--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)

September 22, 2013 at 12:01 pm

#1652200
RE: For Each Loop Uploads the Same File Infinitely

Vikash Kumar Singh (9/21/2013)
If you could share your design of SSIS that might be helpful to resolve this. A different approach that you can try is SSIS: How to load...
--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)

September 22, 2013 at 11:50 am

#1652199
RE: How to Write Query for the Below Requirement?

perireddy.arikatla (9/22/2013)
Thanks For your Valuable Reply Sir.
It works when i give tha Party_code in the where clause
i.e
SELECT party_code, sum(inst_amt) as total_insts,
(Select Sum(paid_amt) as total_paid
...
--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)

September 22, 2013 at 11:29 am

#1652198
RE: Repeating update or replace statement for column

azdeji (9/22/2013)
I want to create an update or replace statement which replaces Event_Code column with repeating values instead for example
B100
B102
B103
....
...
all the way to 10 and repeat again to 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)

September 22, 2013 at 11:25 am

#1652197
RE: Build menu with CTE ....

According to the ID and IDRoot of the test data, your desired output seems to be a bit off if you want these menu items to be sorted in order...
--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)

September 22, 2013 at 9:37 am

#1652195
RE: Want to add Text data

niladri.primalink (9/20/2013)
Sorry For using the word 'it'.
Actually the code what SScrazy sent to me is working for me.
That's why I wrote it is working for me.
If I hurt...
--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)

September 21, 2013 at 10:46 am

#1652143
RE: Reduce the size of database

shiwani.plrs (9/20/2013)
hello
The Size of my database has been increased to 10-20 GB, although the RAM of my server is quite good, still it takes lot of time to open...
--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)

September 21, 2013 at 10:17 am

#1652142
RE: Relationship Question

RedBirdOBX (9/19/2013)
I would like the ability to run a SP to clear out all the test tables in preparation for the next test.
I have a frequent need to do...
--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)

September 21, 2013 at 10:15 am

#1652140
RE: Build menu with CTE ....

PiMané (9/21/2013)
The values that 'name' has are just for ordering porpoise, for easier visualization of the results...
'name' actually has Accounting, Sales, Purchases, Human Resources, etc...
If the "Name" column actually contains...
--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)

September 21, 2013 at 10:06 am

#1652138

Viewing 15 posts - 25,876 through 25,890 (of 59,102 total)