Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,146 through 26,160 (of 59,099 total)

RE: Returning stored procedure results into a CTE or temp table?

cmerrell (8/21/2013)
Excellent suggestion. Also,
insert into #tab
exec (@MyDynamicCode)
But "insert into" will only insert into an existing table. What about creating a new table?
Use SELECT/INTO with OPENROWSET...
--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 21, 2013 at 11:22 pm

#1643749
RE: how to pass parameters into an openquery ?.

SQL Show (8/21/2013)
Can you check this link.
http://support.microsoft.com/kb/314520
Z'actly!
--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 21, 2013 at 11:19 pm

#1643748
RE: how to pass parameters into an openquery ?.

weston_086 (8/21/2013)
Bcz i want to put the result of the stored proc into "dbo.INFORMATION" table.but it is giving me an error "unable to begin a distributed transactions" when i...
--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 21, 2013 at 11:17 pm

#1643747
RE: The Costs of Data

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)

August 21, 2013 at 11:03 pm

#1643745
RE: Trying to iteratively use PATINDEX commands to comb through a large amount of text

CleverSQLUserID (8/5/2013)
Sorry for necro'ing an old thread, but I'm trying to do something similar. The difference is that I'm looking for multiple strings (matching a pattern) of varying lengths. 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)

August 21, 2013 at 10:11 pm

#1643738
RE: BCP Help

jerome.morris (8/21/2013)
Ok, I will look at this, but entertain me
insert [dbo].[AlarmDet]
(JobStart)
select
--convert (Jobsatrt (),101)
--SELECT convert(datetime, '23/07/2009', 103)
--convert (datetime, Jobstart,103)
--CONVERT(varchar, CONVERT(datetime, JobStart), 100)
--cast(JobStart as date)
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)

August 21, 2013 at 7:44 pm

#1643725
RE: Combine related row from 2 tables into single row

What do you want to do if there are more than 2 funding sources?
Also, since you're new, have a look at 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 21, 2013 at 5:05 pm

#1643704
RE: does it make difference nvarchar(50) or nvarchar(500)

aykut canturk (8/21/2013)
dear friends,
I have a large table with more than 10 million records and all fields are "string". I import data from csv file once in a month and...
--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 21, 2013 at 4:28 pm

#1643700
RE: query is taking long time to run

New persopn (8/21/2013)
Hi all
here i am executing the query "select * from tmp_Brad_Product_Configuration_12months"
while executing this it is taking 25 mins above and it is still executing.
what may be the reason....
--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 21, 2013 at 4:10 pm

#1643697
RE: Issues with partitioning...

T.Ashish (8/20/2013)
Gail,
I understood that. And I have read the article you mentioned, its really nice.
Actually I meant this feature...
--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 20, 2013 at 7:07 am

#1643058
RE: Performance Issue: Where do you look?

I believe that one of the most important steps has been missed altogether. You must first confirm that the database appears to be slow by logging onto the app/website...
--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 20, 2013 at 7:01 am

#1643054
RE: MDF file too large. PRIMARY FILE GROUP FULL error

The answer is "simple". You have too much data for Express to handle and will need to delete some or move to a different edition of SQL Server.
--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 19, 2013 at 11:24 pm

#1642946
RE: Adding Columns to report if no data in a given period

The missing months don't need to appear for any of the companies if you use a calendar table or a smaller table with just the months of interest in 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)

August 19, 2013 at 11:19 pm

#1642945
RE: SQL backup on Cluster shared drive or Local drive.

The shared drive is normally some pretty expensive high speed hardware. I'd rather put the backups on a simple and much less expensive network share somewhere. A couple...
--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 19, 2013 at 11:15 pm

#1642943
RE: Shrink does not release space

Erland Sommarskog (8/19/2013)
REORGANIZE essentially performs a bubble-sort of the index. The pages are not changed, so if a page is only 50 % full, it will remain 50% full.
I'm pretty...
--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 19, 2013 at 6:39 am

#1642647

Viewing 15 posts - 26,146 through 26,160 (of 59,099 total)