Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,831 through 31,845 (of 59,099 total)

RE: table performance

znkin (11/28/2011)
Thanks all for the replies...
Apart from what was suggested by all would it help if I made a view and transferred all data in a separate table for 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 28, 2011 at 9:56 pm

#1413761
RE: Enable autogrowth for databases in SQL Server

beejug1983 (11/27/2011)
Hi,
I have to enable autogrowth for around 150+ databases on SQL Server 2005. This is client requirement. I know it is possible by using powershell script in one hit....
--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 28, 2011 at 9:49 pm

#1413758
RE: Enable autogrowth for databases in SQL Server

bruce 1565 (11/28/2011)
This is for one server and includes system databases but I expect you know how to change to your requirements. The single commented lines are where you...
--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 28, 2011 at 9:48 pm

#1413757
RE: Need to format HH:MM:SS

stevefromOZ (11/27/2011)
@jeff - i think you meant SSRS not SSIS, but heck, there's reasons to not like either on any given day :):hehe:
They're all 4 letter words to me. 😀
--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 28, 2011 at 9:40 pm

#1413753
RE: Little Love Lost for SMO

Peter Schott (11/28/2011)
And Jeff, MS is trying to give us job security again. Remember when SQL Server was so easy it didn't need a DBA? 😉
Heh... yup. Now you...
--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 28, 2011 at 9:37 pm

#1413751
RE: Maximum Insert Commit Size

Thanks for the feedback, SonTac.
--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 28, 2011 at 9:23 pm

#1413747
RE: Stress – It’s Not Fair

TravisDBA (11/28/2011)
Great article Andy! I am also reminded of great saying in our business that I use all the time to throw the stress back into their (BA's and PM'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 28, 2011 at 9:15 pm

#1413744
RE: Get Dates of Month listed as Columns

vani_r14 (11/28/2011)
There is nothing in common between these two tables
The Client Details table MUST have something in it that can be referred to by date or can be joined 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)

November 28, 2011 at 9:05 pm

#1413743
RE: To find freespace of Database using a query

bfranklin-557019 (12/7/2007)
----The following will return each local drive and a free space in MBEXEC master.dbo.xp_fixeddrives
----The following function with obtain a supplied drive's capacity
ALTER FUNCTION [dbo].[fnDBDriveStats_GetDriveSize]
(@cDrive char(1))...
--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 27, 2011 at 2:41 pm

#1413204
RE: Need to format HH:MM:SS

I guess that might be yet another reason for me to dislike SSIS. It's a whole lot simpler in T-SQL.
SELECT CONVERT(VARCHAR(10),DATEDIFF(hh,0,DATEADD(ss,SecondsColumn,0)))
+ RIGHT(CONVERT(CHAR(8),DATEADD(ss,SecondsColumn,0),108),6)
--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 27, 2011 at 12:43 pm

#1413197
RE: What else have you done?

BWAA-HAAA!!!! I'm doing the same things as I did before... shoveling manure in a rose garden and feeding people things they sometimes have no taste for. 😛
--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 27, 2011 at 11:41 am

#1413196
RE: To change datetype varchar(14)

rashid_alavi (11/27/2011)
Dear All,
i have column in my table which of datatype varchar(14) (20111107070115) , now i want to change display
2011/11/07 07:01:15 ( DD/MM/YYYY HH:MM:SS)
please help me on 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)

November 27, 2011 at 11:23 am

#1413194
RE: Can't execute queries in SSMS 2008 against SS 2000 databases

I believe Tom has this nailed. The Green Arrowhead used to be the "run" command prior to SQL Server 2000. In 2005 and up, it's now the "run...
--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 27, 2011 at 11:15 am

#1413192
RE: Stress – It’s Not Fair

Heh... you've gotten really good at hitting "hot spots" for me in your articles, Andy. 😀
[Rant ON]
Unless you're the project manager, there's no way to reduce this type of stress...
--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 27, 2011 at 10:27 am

#1413190
RE: Adding a column alias to be the field name in a new table

I have to ask... how many columns do you have in common between the header and detail tables? There should only be one an only one column in common...
--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 27, 2011 at 9:35 am

#1413188

Viewing 15 posts - 31,831 through 31,845 (of 59,099 total)