Viewing 15 posts - 12,646 through 12,660 (of 59,099 total)
Yep... agreed. Performance is second only to accuracy and they're both extremely important.
I was mostly referring to the bloody PARSENAME and the NVARCHAR conversion. I do know that...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 29, 2018 at 12:40 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 28, 2018 at 4:23 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 28, 2018 at 7:44 am
--Jeff Moden
Change is inevitable... Change for the better is not.
March 28, 2018 at 7:39 am
My table holds values like 000.004.000, 000.02.000, 000.024.000. What is the best/easiest way to get...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 28, 2018 at 7:34 am
Predictive analytics isn't BI 🙂 (not by most definitions of the term)
Apparently...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 27, 2018 at 9:09 am
Try specifying a login - something like:
Alter Procedure [dbo].[RemoteLink]
@LinkedServerName Varchar(50)
AS
--With...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 26, 2018 at 7:36 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 26, 2018 at 3:40 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 26, 2018 at 3:22 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 26, 2018 at 3:19 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
March 26, 2018 at 7:39 am
--Jeff Moden
Change is inevitable... Change for the better is not.
March 26, 2018 at 7:33 am
Jeff Moden (1/28/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
March 25, 2018 at 4:57 pm
I have these tables and data:
CREATE TABLE [Table1](
[PartnerSiteID] [int] IDENTITY(1,1) NOT NULL PK,
[PartnerID]...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 24, 2018 at 5:07 pm
I have a sql 2012 server set up with collation Latin1_General_CI_AS (default).
A vendor is performing an...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 24, 2018 at 5:03 pm
Viewing 15 posts - 12,646 through 12,660 (of 59,099 total)