Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,851 through 17,865 (of 59,069 total)

RE: Best Practices - SSIS location

SQL!$@w$0ME (4/13/2016)
Hi Guys,
What are the best practices to implement SSIS server.
Application server?
Existing DB server?
Dedicated server per environment?
one dedicated server for all environments?
Or any other options.
Please share your thoughts. SSIS...
--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)

April 15, 2016 at 8:07 pm

#1872544
RE: How to avoid locking/ daed locking while altering table

Bhushan Kulkarni (4/14/2016)
How can avoid such locking / dead lock issue.
You can't. You can't modify the DDL of a table and expect other users to have access to it.
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)

April 15, 2016 at 7:52 pm

#1872542
RE: Performance issue with Query

T.Ashish (4/15/2016)
This execution time is still not good and I need to optimize it further. There are no index or execution plan issues with this query.
I'm thinking that's a serious...
--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)

April 15, 2016 at 7:36 pm

#1872539
RE: Understand Sharepoint

renato.afonso (4/15/2016)
Sorry, rephrasing: creating indexes on the sharepoint database directly, can do more harm than good.
When making such a claim, you need to provide some form of additional information explaining...
--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)

April 15, 2016 at 7:31 pm

#1872538
RE: Best way to Calculate Human Age from a Birthdate

hrothenb (4/15/2016)
USE [livedb];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
CREATE FUNCTION dbo.GetAge
(@DOB DATETIME,
@ToDate DATETIME
)
RETURNSSMALLINT
AS
BEGIN
DECLARE@Diff SMALLINT,
@f DATETIME,
@T DATETIME
SELECT@Diff = DATEDIFF(month, @DOB, @ToDate) / 12,
@f = DATEADD(year,...
--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)

April 15, 2016 at 7:22 pm

#1872537
RE: What's Your Downtime?

Steve Jones - SSC Editor (4/15/2016)
I'd hope a cloud provider wouldn't have this happen and would have plans for multiple redundancies and the ability to move systems elsewhere. However 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)

April 15, 2016 at 7:11 pm

#1872536
RE: Need to update stats when CPU is high for a particular Query

nagkarjun1 (4/15/2016)
Hey Luis - The Auto update stats is set to true already. But The CPU and no of reads for the bad plan is more and taking over all...
--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)

April 15, 2016 at 6:38 pm

#1872534
RE: BULK INSERT seems not to recognise line terminators

Luis Cazares (4/15/2016)
Mark Dalley (4/15/2016)
Man, it worked. I could have sworn I'd already tried that.
A slight twist though, and an extra confusing factor - the original file was actually Unix...
--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)

April 15, 2016 at 6:33 pm

#1872533
RE: BULK INSERT seems not to recognise line terminators

Mark Dalley (4/15/2016)
Man, it worked. I could have sworn I'd already tried that.
A slight twist though, and an extra confusing factor - the original file was actually Unix format, 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)

April 15, 2016 at 6:31 pm

#1872532
RE: Successful Projects

From the Article:
Sometimes I think the problems in software development aren't that we write poor code, but rather that we rush a complex endeavor, being willing to redo work rather...
--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)

April 14, 2016 at 10:49 am

#1872084
RE: Need to dynamically add grouping based on username

Probably easier to kill the dashboard and rewrite it yourself so that you don't have to continue to tolerate its nuances.
--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)

April 14, 2016 at 10:38 am

#1872079
RE: SQL Server Audits

Adam Sandler (4/14/2016)
Can anyone point me in thright direction to the usefulness of audits.
I have read up about them, have done a few test specifications. Has someone got a good...
--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)

April 14, 2016 at 10:19 am

#1872069
RE: Executing Functions From Table Column

sarath.tata (4/14/2016)
I totally agree with you. Initially they were all Stored Procedures. I changed them to functions as I can't really do EXEC in select query unless 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)

April 14, 2016 at 10:03 am

#1872060
RE: Executing Functions From Table Column

sarath.tata (4/14/2016)
I may not have conveyed my question properly. This is how I achieved my solution. I understand my code references tbl and fn but I have...
--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)

April 14, 2016 at 9:42 am

#1872044
RE: Creating an Index Strategy

Grant Fritchey (4/14/2016)
I've seen this argument before, and I actually lean towards what Jeff & Brent are advocating... if your queries are primarily seek. If you've tuned the system so...
--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)

April 14, 2016 at 9:36 am

#1872037

Viewing 15 posts - 17,851 through 17,865 (of 59,069 total)