Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,111 through 31,125 (of 59,101 total)

RE: How to convert XML to a datatable in sql server

mvijaykumar.mca (2/15/2012)
Hi all..
How to convert XML to a datatable in sql server?? or inside a stored procuedure (not using pgmg lang like C# etc. ).
i couldnt get 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)

February 15, 2012 at 10:46 pm

#1447659
RE: When we should use in a query or a procesure "option(recompile)"

If one second is what you need it to be (especially compared to 30 minutes), why mess with success? Leave the option to recompile in the 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)

February 15, 2012 at 10:39 pm

#1447657
RE: HELP...exporting multiple spreadsheets to multiple SQL tables with foreign keys.

All of that wonderment goes to hell in a handbasket if someone has the spreadsheet open at run time. Wouldn't it be better and simpler to provide the user...
--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)

February 15, 2012 at 10:31 pm

#1447656
RE: reading html

LutzM (2/15/2012)
Would a rather standard REPLACE help?
Heh... there you go again! Making stuff simple. 😛
--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)

February 15, 2012 at 10:26 pm

#1447653
RE: How to ignore errors & insert data in a table

Gianluca Sartori (2/15/2012)
However, you could check the values in advance and import valid rows only.
Heh... WHAT a concept!! 🙂 Actually checking data instead of throwing it against the wall 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)

February 15, 2012 at 10:23 pm

#1447652
RE: How to ignore errors & insert data in a table

jcb (2/15/2012)
ISNUMERIC is not perfect since chars like .+- can fool it.
But if you use like it:
ISNUMERIC(value + 'e0')
ill improve correctness a lot.
In this case, the improvement of "correctness"...
--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)

February 15, 2012 at 10:16 pm

#1447650
RE: How to backup only new data?

halifaxdal (2/15/2012)
Hi folks,
I have privilege to a table on a database in remote server, the table has 20+ fields and over 70k records.
I need to back up them to my...
--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)

February 15, 2012 at 10:02 pm

#1447645
RE: sp_executesql()

PHXHoward (2/15/2012)
Hi,
Does anyone know why or how sp_executesql() affects query performance?
I found today that a select statement took 11 minutes to complete when it was inside sp_executesql().
Taking it out 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)

February 15, 2012 at 9:54 pm

#1447644
RE: SA for database ownership?

SQLDCH (2/8/2012)
You're exactly right Jeff, I completely mis-spoke. I meant to say that they suggest that blanket ownership by the 'sa' account is not a best practice, which is...
--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)

February 15, 2012 at 9:37 pm

#1447642
RE: March 13, 2010: PSSUG SQL Camp, pre-Call For Speakers

SPAM reported.
--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)

February 15, 2012 at 9:24 pm

#1447638
RE: Mulitple Saarch Criteria using ONE Column

🙂
I did say that I've tested this before. :hehe:
--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)

February 15, 2012 at 9:20 pm

#1447636
RE: Need Query Help Urgent

Jing. (2/6/2012)
Then this will return only those students who had 5 AND 10 but not 15
create table student ( stdnt_id int, stdnt_name varchar(50),stdnt_activity SMALLINT )
go
INSERT INTO student
select 1, 'kiran',...
--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)

February 15, 2012 at 9:15 pm

#1447635
RE: How to convert YYYYMMDD to datetime using SSIS Data Conversion?

banu2316 (2/14/2012)
How to convert 20 jan 2012(string) into 2012-01-20 using derived column?
I don't know how to do it in SSIS but here's how it can be done in T-SQL.
...
--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)

February 15, 2012 at 8:57 pm

#1447631
RE: COUNT No of occurrances in a text field

SGT_squeequal (1/30/2012)
Lo here is what i used, instead of counting the number of occurances to get my while loop to only run that many times it loops untill the value...
--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)

February 15, 2012 at 8:21 pm

#1447626
RE: List of recommended performance alerts?

I've not had to setup such alerts for years but I used to setup for 95% CPU (each cpu), 95% memory, blocks that lasted longer than a minute, and 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)

February 15, 2012 at 7:53 pm

#1447624

Viewing 15 posts - 31,111 through 31,125 (of 59,101 total)