Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,881 through 17,895 (of 59,098 total)

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
RE: Creating an Index Strategy

TheSQLGuru (4/14/2016)
Jeff, the next time you and I are together FTF (SQL Saturday or PASS Summit?) we need to have a long, detailed talk about the things you state below....
--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:30 am

#1872034

Viewing 15 posts - 17,881 through 17,895 (of 59,098 total)