Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,121 through 36,135 (of 59,099 total)

RE: Why SHRINKFILE is a very bad thing, and what to do about it.

george25 (11/9/2010)
I have quite a few very large databases and, like Giles above, I need to shrink the log files after large amounts of data are imported into the databases....
--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)

November 9, 2010 at 8:29 am

#1248339
RE: Calculate number of moths between two days?

parthi-1705 (11/4/2010)
adonetok (11/3/2010)
How to calculate number of moths between two days?
For example, BeginingDt=09/01/2007, EndingDt=05/20/2009 should be list as below:
2007:4
2008:12
2009:5
Hi
Craig Farrell has used a table you can avoid 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)

November 8, 2010 at 8:32 am

#1247689
RE: Efficient ways to reset lost sql sa password

wayne.mcdaniel (10/25/2010)
Jeff Moden (10/24/2010)
yitiana (9/19/2010)
Have you ever forgot or lost your SQL Server sa password?
I'm always amazed at how many people do such a thing.
Probably more likely that the 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)

November 8, 2010 at 8:28 am

#1247685
RE: Any limits in number of actions in a single transaction??

First, "TRY" doesn't start a transaction. You have to use a BEGIN TRANSACTION/COMMIT pair to encapsulate all that you wish to do in a transaction. And no, there's...
--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)

November 8, 2010 at 8:07 am

#1247676
RE: Are the posted questions getting worse?

Shifting gears, I'm alive and well and in the Paramount hotel in Seattle which is located and 8th and Pine... just a couple of blocks from the convention center. ...
--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)

November 7, 2010 at 8:35 am

#1247455
RE: Are the posted questions getting worse?

Jack Corbett (11/5/2010)
LutzM (11/5/2010)
Jack Corbett (11/5/2010)
...
Diagnosis is in. Displaced fracture about 2 inches below the elbow which requires surgery to be set properly. Local ortho doesn't do kids...
--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)

November 7, 2010 at 8:03 am

#1247453
RE: Please send me Interview Q &A

Now... to get a "start" in SQL (and I do mean just a start... it takes a lot of practice to get really good at it), try http://www.w3schools.com . ...
--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)

November 7, 2010 at 7:28 am

#1247451
RE: Please send me Interview Q &A

sankarkot2007 (11/6/2010)
Hello Da-Zero
don't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
Allow me to give a friendly warning. Asking for interview questions on...
--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)

November 6, 2010 at 6:40 pm

#1247425
RE: UDF in UPDATE affect performance ???

Ah... understood. Thanks, Lynn.
--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)

November 5, 2010 at 8:26 am

#1247157
RE: Sending E-Mail from SQL 2008 Express

I have to ask because I just don't know... Hopefully, one of you do. Is CDONTS and sp_OA* available in SQL Server Express?
--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)

November 4, 2010 at 7:46 pm

#1246965
RE: UDF in UPDATE affect performance ???

karthikeyan-444867 (11/3/2010)
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION [dbo].[fnGetAsset]
(
@AssetIDINT
,@AssetType_CodeINT
)
RETURNS INT
AS
BEGIN
DECLARE @DataSourceIDINT
DECLARE @AssetTypeNameVARCHAR(100)
SET @AssetTypeName = dbo.fnGetValueAndType(@AssetType_Code, 'AssetType')
IF @AssetID IS NULL OR @AssetType_Code IS NULL
SET @DataSourceID = NULL
ELSE
BEGIN
IF UPPER(@AssetTypeName) = 'HFUND'
SELECT...
--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)

November 4, 2010 at 7:38 pm

#1246961
RE: UDF in UPDATE affect performance ???

Lynn Pettis (11/4/2010)
tfifield (11/4/2010)
UDF's don't necessarily hurt performance. I write UDF's all the time to do string manipulation type actions. These aren't much slower than built in functions...
--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)

November 4, 2010 at 7:36 pm

#1246960
RE: UDF in UPDATE affect performance ???

karthikeyan-444867 (11/2/2010)
All,
will UDF in an UPDATE statement affect the performance? I hope so.
UPDATE #Result
SET DataSourceID = dbo.fnGetAsset(AssetID, AssetType_Code)
Assume #Result table has 400000 records.
Innputs are welcome!
Karthik... you and I go 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)

November 4, 2010 at 7:27 pm

#1246958
RE: Is xp_cmdshell the only option?

Jeff Moden (11/4/2010)
Randy Doub (11/4/2010)
I think using an Agent Job is a great idea since the account that runs my Agent already has xp_cmdshell privileges.[/quote-0]
Correct. Create a job with...
--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)

November 4, 2010 at 7:24 pm

#1246957
RE: Is xp_cmdshell the only option?

Randy Doub (11/4/2010)
I have a vendor system with a SQL2008 back end. We put their database on a large server that houses several other databases because of the large...
--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)

November 4, 2010 at 7:23 pm

#1246956

Viewing 15 posts - 36,121 through 36,135 (of 59,099 total)