Viewing 15 posts - 17,851 through 17,865 (of 59,069 total)
SQL!$@w$0ME (4/13/2016)
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
Change is inevitable... Change for the better is not.
April 15, 2016 at 8:07 pm
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
Change is inevitable... Change for the better is not.
April 15, 2016 at 7:52 pm
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
Change is inevitable... Change for the better is not.
April 15, 2016 at 7:36 pm
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
Change is inevitable... Change for the better is not.
April 15, 2016 at 7:31 pm
hrothenb (4/15/2016)
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
Change is inevitable... Change for the better is not.
April 15, 2016 at 7:22 pm
Steve Jones - SSC Editor (4/15/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2016 at 7:11 pm
nagkarjun1 (4/15/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2016 at 6:38 pm
Luis Cazares (4/15/2016)
Mark Dalley (4/15/2016)
A slight twist though, and an extra confusing factor - the original file was actually Unix...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2016 at 6:33 pm
Mark Dalley (4/15/2016)
A slight twist though, and an extra confusing factor - the original file was actually Unix format, with...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 15, 2016 at 6:31 pm
From the Article:
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2016 at 10:49 am
Probably easier to kill the dashboard and rewrite it yourself so that you don't have to continue to tolerate its nuances.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2016 at 10:38 am
Adam Sandler (4/14/2016)
I have read up about them, have done a few test specifications. Has someone got a good...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2016 at 10:19 am
sarath.tata (4/14/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2016 at 10:03 am
sarath.tata (4/14/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2016 at 9:42 am
Grant Fritchey (4/14/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
April 14, 2016 at 9:36 am
Viewing 15 posts - 17,851 through 17,865 (of 59,069 total)