Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,276 through 10,290 (of 59,102 total)

RE: Rebuild index taking time

pietlinden - Thursday, December 20, 2018 8:33 PM
This might be a helpful read:
https://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/
Lordy, don't use REORGANIZE. It'll take longer, beat 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)

December 20, 2018 at 10:46 pm

#2017013
RE: Convert string MMDDYYYY to a date

Since you're using SQL Server 2012, DATEFROMPARTS with substrings to isolate the parts might be the fastest.
Of course my initial thought is to ask that they send...
--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)

December 20, 2018 at 10:36 pm

#2017012
RE: urgent

Welcome. I suggest that you first download a free copy of SQL Server 2016 or 2017 Developers Edition, install it on your computer, buy a book on the subject 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)

December 20, 2018 at 10:30 pm

#2017011
RE: Getting distinct values from multiple lines??

jbalbo - Thursday, December 20, 2018 3:08 PM
Hi
I am trying to get distinct values from multiple filed on multiple lines per "client"
example
Client ...
--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)

December 20, 2018 at 10:24 pm

#2017010
RE: Set @rptStartDate = CASE WHEN 'TransactionCount' = 2 Then '11/1/2018' - 30 days Else '11/1/2018' End

jcelko212 32090 - Wednesday, December 19, 2018 1:50 PM
patrickmcginnis59 10839 - Wednesday, December 19, 2018 12:53 PM
--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)

December 20, 2018 at 1:32 pm

#2016987
RE: Get Temp Table definition

Jonathan AC Roberts - Thursday, December 20, 2018 9:13 AM
I really like this script. Just been using it to create definitions or...
--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)

December 20, 2018 at 1:06 pm

#2016983
RE: Using Hash values as Dimension Keys in Datawarehouse

Heh... hold the phone.... If you have a user ID (and assuming that it's unique), why do you need another surrogate key to begin with??? :blink:
--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)

December 20, 2018 at 8:59 am

#2016964
RE: XML Data Loading - Issue

I have to agree with Eirikur... Keep It Super Simple. If you must use SSIS for this, have it call a stored procedure that does what he said.
--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)

December 20, 2018 at 8:56 am

#2016961
RE: SQL Crash "The transaction log for database 'master' is full due to 'CHECKPOINT'"

kvacola - Thursday, December 20, 2018 8:26 AM
We don't normally backup the "M" databases, but we're definitely considering it now. The one...
--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)

December 20, 2018 at 8:45 am

#2016956
RE: Are Database Upgrade Advisor and Data Migration Assistant the same things?

My understanding (from reading when I tried to use it the first time) is that the DMA also shares a shedload of information about your databases and servers with Microsoft,...
--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)

December 20, 2018 at 8:42 am

#2016955
RE: Removing Extended Properties

I have to agree with the customer. Having meta-data that identifies a column in such a fashion is as dumb as labeling a column as "SSN" or "TaxID" even when...
--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)

December 20, 2018 at 8:38 am

#2016954
RE: SQL Crash "The transaction log for database 'master' is full due to 'CHECKPOINT'"

kvacola - Wednesday, December 19, 2018 4:04 PM
Solved! We were able to grab the master.mdf and mastlog.ldf from an image backup a...
--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)

December 20, 2018 at 8:01 am

#2016948
RE: Deploy the Database First

mig28mx - Wednesday, December 19, 2018 3:31 PM
Hi,
In my case, I deploy both: db changes and also code changes. To handle 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)

December 20, 2018 at 7:58 am

#2016947
RE: Failure sending mail: Failure sending mail

sizal0234 - Wednesday, December 19, 2018 2:46 PM
USE [ReportServer]
go
SELECT
d.SubscriptionID
,e.name AS ReportName
,e.path AS ReportPath
,d.LastStatus
,d.LastRunTime
,u.UserName
FROM dbo.Subscriptions...
--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)

December 20, 2018 at 7:52 am

#2016945
RE: Looping Through Data

jcelko212 32090 - Wednesday, December 19, 2018 3:39 PM
irehman - Wednesday, December 19, 2018 10:40 AM
--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)

December 20, 2018 at 7:48 am

#2016944

Viewing 15 posts - 10,276 through 10,290 (of 59,102 total)