Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,021 through 22,035 (of 59,072 total)

RE: How to check for duplicate records by comparing columns from three tablespaces

muralikrishna2489 (1/5/2015)
There will be millions of records in "ChangesFunction_maintable. So will my database gets slow while using UNION ALL ?
Yes. It could get quite slow. I only...
--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)

January 5, 2015 at 7:58 am

#1767773
RE: How to check for duplicate records by comparing columns from three tablespaces

Here's one way to do it. UNION ALL treats dupes as equals so no need for the ISNULL thing. As usual, details are in the comments.
WITH
cteGetAllRows AS
( --===...
--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)

January 5, 2015 at 12:55 am

#1767673
RE: Backups to tape - how to check.

Joy Smith San (1/4/2015)
Confirmed they haven't configured anything.
I checked it further, found device_type = 7 and hence assume its the VSS backup updating backupset table in msdb database (Not sure...
--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)

January 5, 2015 at 12:36 am

#1767668
RE: Into Clause in SQL Server

PRAMANA.DBA (1/2/2015)
Hi,
How to create table without identity by using * into option.
ex: Select * Into Employee_History From Employee.
I don't want identity column in History table, But columns and datatypes should...
--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)

January 5, 2015 at 12:26 am

#1767666
RE: How to check for duplicate records by comparing columns from three tablespaces

It seems like two UNION ALLs would do the trick.
--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)

January 5, 2015 at 12:19 am

#1767665
RE: How to Import Data from Excel sheet to Sql server 2008

And, yeah... there will be an article coming out on this. I have to make a couple of tweaks to handle different types of groupings.
--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)

January 4, 2015 at 9:55 pm

#1767660
RE: How to Import Data from Excel sheet to Sql server 2008

Ok, here we go. I first had to make a couple of assumptions. which is why this code looks a little complicated.
1. 3 months isn't going to be...
--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)

January 4, 2015 at 9:47 pm

#1767659
RE: What To Do When the Import and Export Wizard Fails - Part II Exports

Yakov Shlafman (12/19/2014)
Thanks. I agree I communicated multiple things with an assumption that my reader is a beginner. How I could do it better?
Highlight the key to the process by...
--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)

January 4, 2015 at 7:55 pm

#1767653
RE: Split Columns of Months into Columns of Weeks

Still, enquiring minds want to know, what is the "YearMonth" column for?
--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)

January 4, 2015 at 7:49 pm

#1767652
RE: insert data into two tables

Eirikur Eiriksson (1/4/2015)
Jeff Moden (1/4/2015)
Eirikur Eiriksson (1/4/2015)
The MERGE does produce an optimal plan for the operation, single scan of both the source table and the first destination table, one merge...
--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)

January 4, 2015 at 2:03 pm

#1767627
RE: How to Pivot column to rows within a Group

For more information on how that works and an alternative along with some performance testing, please see the following article...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

January 4, 2015 at 12:01 pm

#1767624
RE: how to create master table in sql

shashianireddy (1/3/2015)
a
Deleting an original post is a real quick way to lose friends. 😉
--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)

January 4, 2015 at 10:58 am

#1767622
RE: Are the posted questions getting worse?

Lynn Pettis (1/3/2015)
Jeff Moden (1/3/2015)
It's only the 3rd of the year and I believe we already have a candidate for the year's most vague question.
http://www.sqlservercentral.com/Forums/Topic1648047-2799-1.aspx
Anyone have even 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)

January 4, 2015 at 10:54 am

#1767621
RE: insert data into two tables

Eirikur Eiriksson (1/4/2015)
The MERGE does produce an optimal plan for the operation, single scan of both the source table and the first destination table, one merge operation on the first...
--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)

January 4, 2015 at 10:50 am

#1767620
RE: how to rewrite query to avoid duplicate records (across columns)

asita (1/3/2015)
Please see below sample data
insert into #MyPhoneList values (123456789,'King@travel.com',null,'b.king@gmail.com',0,0,1,1,0,1)
insert into #MyPhoneList values (234567891,'drew@cocacola.com','drew@cocacola.com',null,1,1,1,1,0,1)
insert into #MyPhoneList values (345678912,'bob@chase.com',null,'kuya@gmail.com',1,0,1,1,0,1)
insert into #MyPhoneList values (456789123,null,'cmith@aix.com','bbc.king@gmail.com',1,1,1,1,1,1)
insert into #MyPhoneList values ...
--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)

January 4, 2015 at 10:24 am

#1767619

Viewing 15 posts - 22,021 through 22,035 (of 59,072 total)