Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,036 through 22,050 (of 59,098 total)

RE: BCP Cannot access a network share

Ron.James (1/5/2015)
Hmmm, why should my credentials need to make it out to the Server. The credentials that SQL Server is running under are already sufficient to read the file...
--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 6, 2015 at 12:36 am

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

navbingo20 (1/5/2015)
@jeff Moden :
First of all, i am very sorry for the delayed response..
it is perfectly working .. only one thing to be noted is , after downloading...
--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 6, 2015 at 12:27 am

#1767972
RE: NEED COLUMN NAMES FROM TABLE DYNAMICALLY

Kannan Vignesh (1/5/2015)
hi ,
i studied , it ll not allowed to table get lock. DBA team suggests that it ll increase your query performance. eg, try with nolock and with...
--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 6, 2015 at 12:22 am

#1767971
RE: NEED COLUMN NAMES FROM TABLE DYNAMICALLY

Kannan Vignesh (1/5/2015)
thanks for your clarification. i will correct it.
Ok jeff. with out nolock, if many peoples accessing same table means it cause any performance issue..?
thanks
Kannan.
Only if there's bad code...
--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 6, 2015 at 12:17 am

#1767969
RE: BCP Cannot access a network share

Ron.James (1/5/2015)
Thanks for the reply and sorry for the confusion over BCP.
I'm really quite sure its not as simple as file share permissions. I've been looking at...
--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 5:39 pm

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

@Navin,
Any feedback on this? Did it work for you 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)

January 5, 2015 at 5:04 pm

#1767920
RE: BIDS 32bit or 64 bit application?

it.anishmca (1/5/2015)
Hey Folks,
I am facing an error issue while installation of 32-bit SQL Server BIDS on my 64-bit Windows-7 professional Edition.
Kindly help.
It would probably help if you told us what...
--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 4:47 pm

#1767913
RE: Backup 500GB SQL database and copy across to a remote server, to be restored.

Lempster (1/5/2015)
Jeff Moden (1/5/2015)
For the initial sync (a few terabytes), our guys went down to the DR site, unbolted the SAN, brought it to the production site, did the copy...
--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 9:30 am

#1767811
RE: Reclaim unused space / Rebuild table

Using SHRINK fragments all indexes in the database on a massive scale. I wouldn't do it unless something really bad and huge happened to the database and then I'd...
--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 9:17 am

#1767809
RE: Employee or Consultant?

I enjoy some of the best of both worlds.
As an FTE, I work with a great team that includes everyone from the owners, through the C-Level, local managers, right down...
--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 8:22 am

#1767789
RE: Backup 500GB SQL database and copy across to a remote server, to be restored.

Lempster (1/5/2015)
Depending on the bandwidth of your network and how far way the 3rd party datacenter is, you may find it quicker to copy the backup to an encrypted external...
--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 8:05 am

#1767779
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

Viewing 15 posts - 22,036 through 22,050 (of 59,098 total)