Jeff Moden

Forum Replies Created

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

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
RE: How to specify login and password in a script while configuring replication with TSQL

elea.grig - Thursday, December 20, 2018 6:35 AM
I know that it is not that good idea to specify login and password directly...
--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:43 am

#2016942
RE: restore multi database

Heh... you do have to ask the right question when using yabingooglehoo. 😀 Try the following search ...
https://www.google.com/search?q=script+to+find+and+restore+latest+backups+sql+server
--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:38 am

#2016940
RE: Queries to practice compilation and recompilation.

Tac11 - Monday, December 17, 2018 9:40 AM
Hi expert,
Can someone please post here some quires (or simulate recompilation) to practice compilation/recompilation? 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)

December 20, 2018 at 7:21 am

#2016938

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