Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,641 through 17,655 (of 59,069 total)

RE: take some data from excel through sql

georgheretis (5/18/2016)
i am using the tool "XLS to CSV Converter' see attachment
Any chance of you attaching that as a ZIP file instead of a RAR file? Thanks.
--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)

May 18, 2016 at 8:16 am

#1879883
RE: Is there any way to find who deleted the database

prasanname2005 (5/17/2016)
Issue : one job which runs for every 5 minutes failed today (completed successfully yesterday) with error one of the object database.dbo.Table was not found.
The database was not...
--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)

May 18, 2016 at 12:04 am

#1879742
RE: Preview your Article/Script

Steve Jones - SSC Editor (5/17/2016)
That's likely not going to happen soon. Resource constrained and I haven't seen anyone else report paste issues in the editor.
Crud. I've tried it...
--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)

May 17, 2016 at 5:04 pm

#1879719
RE: take some data from excel through sql

georgheretis (5/17/2016)
Hi
I have a problem
I want to have a .csv File with the following format , some fields like ‘actors’ , ‘directors’ , ‘date’ and ‘date of pomotion’
The problem is...
--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)

May 17, 2016 at 8:39 am

#1879556
RE: Table to table copy performance mystery - 5 billions rows.

You have to do this wholesale copy job on a regular basis??? :blink:
If so, consider putting that table in a database of it's own and use synonyms to point to...
--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)

May 17, 2016 at 8:33 am

#1879554
RE: Preview your Article/Script

Steve Jones - SSC Editor (5/16/2016)
I agree. I think there was some issue with the permissions and getting this working, but I'll add this to the list.
It would also 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)

May 16, 2016 at 3:58 pm

#1879388
RE: Kill The Sessions

Iwas Bornready (5/16/2016)
Don't know why I didn't find this sooner. Thanks.
Ooooo.... be really careful here. Yes, it avoids killing things that are "Runnable" but it does not avoid killing...
--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)

May 16, 2016 at 3:50 pm

#1879386
RE: Dynamic data masking feature

Thanks, Steve. I appreciate it.
--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)

May 16, 2016 at 3:29 pm

#1879379
RE: Finding if there was CPU or memory pressure yesterday night

coolchaitu (5/16/2016)
A DBA maintenance job failed yesterday night. Is there a way to find if there was CPU or memory pressure when this job ran yesterday night..
Rather than jumping to...
--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)

May 16, 2016 at 3:15 pm

#1879376
RE: SSIS automation through command line

Hmmm... I consider the Kerberos "double hop problem" to be a security feature rather than a fault and have been asked to eliminate the "problem" many times and have simply...
--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)

May 16, 2016 at 3:13 pm

#1879375
RE: Dynamic Data Masking

Iwas Bornready (5/16/2016)
It may serve us well for the HIPAA regs.
It'll be interesting to see what shakes out there. As stated in the article, it's not a form of...
--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)

May 16, 2016 at 10:02 am

#1879308
RE: Are the posted questions getting worse?

Lowell (5/16/2016)
Complete non-sequitur here guys, but I'm rather pleased with myself.
I just got my MCSA after taking 70-463 Implementing a Data Warehouse in SQL Server 2012/2014.
I had set a mental...
--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)

May 16, 2016 at 9:58 am

#1879307
RE: T-SQL query error while datetime conversion

sqlnaive (5/16/2016)
drew.allen (5/16/2016)
sqlnaive (5/16/2016)
I've one table with one specific integer column containing date as YYYYMMDD format and apart from date it also may contain value 99999999. I'm using this table...
--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)

May 16, 2016 at 9:50 am

#1879304
RE: Fiscal year concat not works in Sqlserver 2008

At this point, you might want to consider building a "Calendar Table". There are a lot of good articles out there on the subject that you can Google.
--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)

May 16, 2016 at 6:05 am

#1879207
RE: T-SQL query error while datetime conversion

As a test, have you tried to create a view consisting only of the BusinessDate column calculation and none of the other columns? That would be my first "Sherlock...
--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)

May 16, 2016 at 5:52 am

#1879205

Viewing 15 posts - 17,641 through 17,655 (of 59,069 total)