Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,101 through 35,115 (of 59,099 total)

RE: find top 50 values from 90% records of table.

abhas (2/10/2011)
Hi friends,
I am having a table that contains 100000.these are log file.among this depending upon fastest responce i have to find 90% records i.e. 900000 first and among this...
--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 13, 2011 at 11:42 am

#1286175
RE: Genrate .txt file through SQL server 2005 stored procedure

Sourav-657741 (2/10/2011)
how to create 10 files using xp_cmdshell?
"It depends" on where the data for the files is coming from. Personally, I create a .bat file and call that 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)

February 13, 2011 at 11:33 am

#1286174
RE: Genrate .txt file through SQL server 2005 stored procedure

pduplessis-723389 (6/2/2008)
Any specific reason why it HAS to happen in a stored proc?
Ummm... because it's damned convenient? 🙂
--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 13, 2011 at 11:30 am

#1286173
RE: Must Declare the Table Variable

shaikh.kurshid (2/11/2011)
Hi,
declare @table table
select * into @table
from abc
Am i need to give all columns in table variable or else can i do directly copying from table1 to 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)

February 13, 2011 at 11:26 am

#1286172
RE: How's This Trigger?

Just my 2 cents...
I don't trust other people's code when it comes to the database especially since the data in most of my databases also has to stand up in...
--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 13, 2011 at 11:17 am

#1286171
RE: Exporting varbinary(max) column take a whole day

In that case, I recommend reading up on BCP exporting as a "Native" format in Books Online.
--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 13, 2011 at 10:31 am

#1286166
RE: BCPing out a Table without xp_cmdshell

prasadau2006 (2/9/2011)
declare @cmdstr1 varchar(500)
select @cmdstr1='BCP "select * from AdventureWorks.dbo.Employee" queryout \\'+upper(Substring(@@SERVERNAME,1,1))+lower(Substring(@@SERVERNAME,2,len(@@SERVERNAME)))+'\Information\HR\AdventureWorks.dbo.Employee.csv -c -t"," -S'+@@servername + ' -T'
exec master.dbo.xp_cmdshell @cmdstr1
Hii, Currently iam using the above query, but i was advised not...
--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 13, 2011 at 9:59 am

#1286164
RE: BCPing out a Table without xp_cmdshell

opc.three (2/10/2011)
Vote for this connect item if you agree that we should have an in-process EXPORT command:
https://connect.microsoft.com/SQLServer/feedback/details/224026
I voted for it. What's amazing is the item was marked as being...
--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 13, 2011 at 9:57 am

#1286163
RE: table design question

Wouldn't it just be easier to make two "control" stored procs? One to run task 2 followed by task 5 and another to run the others in the proper...
--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 13, 2011 at 9:51 am

#1286162
RE: Trouble when count by week in SQL

Nicely done, Ron. It's amazing what a little provided data can do.
As a side bar, we still need to know what the OP's definition of "a week" 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 13, 2011 at 8:38 am

#1286156
RE: Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit

eharper (11/21/2008)
Is there any way to increase the command timeout in DBFit?
I would like to test some complex data warehouse ETL stored procedures, but I've hit a problem as several...
--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 12, 2011 at 5:55 pm

#1286088
RE: Very Complicate Query....

LutzM (2/12/2011)
Glad I could help 😀
It's not my job to judge but I've got to say it anyway... nice job, Lutz! 🙂
--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 12, 2011 at 5:51 pm

#1286087
RE: how to remove duplicates irecords in a table

This is a very common and easily searched problem. In this case, Google is your friend...
http://www.google.com/search?hl=en&source=hp&biw=1276&bih=561&q=sql+server+remove+duplicates&aq=0&aqi=g10&aql=f&oq=SQL+SERVER+REMOVE+Duplicates
--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 12, 2011 at 12:59 pm

#1286060
RE: Are the posted questions getting worse?

Tom.Thomson (2/12/2011)
Koen Verbeeck (2/12/2011)
The Dixie Flatline (2/11/2011)
QA is where some developers send their code to see if it works correctly or not. Often they do this without verifying...
--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 12, 2011 at 10:41 am

#1286041
RE: Are the posted questions getting worse?

Tom.Thomson (2/12/2011)
Craig Farrell (2/11/2011)
Anyone here mind if I cut loose on him? I truly believe he'll be tasty. I wanna eat him.
My view is that if you're certain...
--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 12, 2011 at 10:32 am

#1286040

Viewing 15 posts - 35,101 through 35,115 (of 59,099 total)