Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,726 through 49,740 (of 59,099 total)

RE: Is T-Sql really that hard to learn?

jimige257 (6/24/2008)
Getting a hand from those with the knowledge makes a big difference...
I absolutely agree! However, I've only been asked a couple of times for help... is 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)

June 25, 2008 at 4:51 am

#833800
RE: Advise on this query

Try it... if it's too slow, tweak it. If you run out of tweaks, try a differect tactic.
--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)

June 24, 2008 at 9:31 pm

#833687
RE: Delete all records in database older than 2 years

The first delete will probably be a good size one... but if you delete every day, the number of rows older than 2 years won't be that big... you won't...
--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)

June 24, 2008 at 9:25 pm

#833683
RE: Find number of weekdays(Monday,Tuesday..) between two dates yearwise

bpbhalerao (6/24/2008)
Thanks Michael,
But I am not getting exactly how to find the total no. of weekdays in that year using the 'Tally' table. Can you please explain some what more?
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)

June 24, 2008 at 9:21 pm

#833681
RE: Help with a while loop

You'll find that loops have problems like the one you just saw because they return multiple result sets. You also find that, comparitively speaking, they're horribly slow. Since...
--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)

June 24, 2008 at 9:16 pm

#833679
RE: Stored Procedure Intermittent Problems

Caching an old execution plan and/or parameter sniffing could be the problem. Add the WITH RECOMPILE option to the proc and see if that problem goes away.
--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)

June 24, 2008 at 9:09 pm

#833678
RE: database tuning engine problem

Yeah... I guess we strayed quite a bit. Sorry...
I've never seen that type of problem occur... If I do and I can actually fix it, I'll try to find...
--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)

June 24, 2008 at 9:06 pm

#833677
RE: XP_cmdshell

keerthy.vishweshwarachar (6/24/2008)
Hi,
Can any one help me to copy the file from ftp server to local server using xp_cmdshell.
Note: I wanted to do this through procedure.
Simple copy command is working...
--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)

June 24, 2008 at 9:04 pm

#833676
RE: Sluggish row painting in SQL Server Management Studio

Juergen.Guenther (6/24/2008)
Hello.
i have the same problem with Dell Latitude D830 - unfortunatly changing the video card is no option for my laptop 🙁
Disabling the hardware acceration worked - but 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)

June 24, 2008 at 9:01 pm

#833673
RE: Is T-Sql really that hard to learn?

jimige257 (6/24/2008)
Is it worth spending 2 hours optimizing a prodedure that works now and is needed last week? Many would say not.
And, THAT is why I tell folks that every...
--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)

June 24, 2008 at 8:57 pm

#833671
RE: SQL Queries on Date function

Saroj (6/24/2008)
Below is the desc:-
Authors Books
Pk Author ...
--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)

June 24, 2008 at 7:56 pm

#833667
RE: How to export sql server data into multiple excel sheets ?

balasach82 (6/12/2008)
I am Balaji new to this discussion. My Code is::
exec xp_cmdshell 'copy C:\templates\BALAJI1.xls C:\export\BALAJI1.xls'
insert into OPENROWSET(
'Microsoft.Jet.OLEDB.4.0',
...
--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)

June 24, 2008 at 7:43 pm

#833666
RE: Write to text file in ASCII not UTF 16

Did anyone ever find an answer on this? If not, does anyone know the answer for 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)

June 24, 2008 at 7:29 pm

#833664
RE: Importing from Excel and displaying in Excel (IS THIS POSSIBLE?)

The answer is "Yes"... both can be done. Create a view in SQL Server to look at the data you want and then create a spreadsheet to use "External...
--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)

June 24, 2008 at 7:28 pm

#833663
RE: Sum values between two dates

So, Bob! Just curious... did Jack's code work or what?
--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)

June 24, 2008 at 7:25 pm

#833662

Viewing 15 posts - 49,726 through 49,740 (of 59,099 total)