Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,161 through 23,175 (of 59,102 total)

RE: Back from Sabbatical

bitbucket-25253 (7/21/2014)
WELCOME HOME
We have something special in our little technology niche, and I hope all of you appreciate it.
I am sure all the site users appreciate the help/knowledge it/that has...
--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)

July 21, 2014 at 11:59 am

#1731135
RE: Not Good Enough For Government Work

From the article...
It is very difficult to explain in simple terms why the principles of relational database are so important. To be able to safely determine whether a system requires...
--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)

July 21, 2014 at 11:57 am

#1731134
RE: How to efficiently import data in .rpt format into SQL 2008

Ok... I took the time to find your BCP format file and the example text file. This is easy. All the columns need to be treated as fixed...
--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)

July 21, 2014 at 11:41 am

#1731129
RE: How to efficiently import data in .rpt format into SQL 2008

halifaxdal (7/21/2014)
David Burrows (7/21/2014)
halifaxdal (7/17/2014)
Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to bigint.
If the files were output by SSMS set to output to file then...
--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)

July 21, 2014 at 11:31 am

#1731124
RE: Generate script to restore log backups

Jack Corbett (7/21/2014)
SQLRNNR (7/21/2014)
I am a bit surprised this hasn't been asked yet and it seems REALLY important.
Why do you have 2000 log backups to restore?
If you truly...
--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)

July 21, 2014 at 11:22 am

#1731118
RE: Simple question: How many users are connected to the sql server (instance)?

smtzac (7/21/2014)
Thank you Shawn for your reply. I am bit confuse here, when I run your query I get total no. 97 (when i add all) but when I run...
--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)

July 21, 2014 at 11:14 am

#1731111
RE: Search File with Widecard

QQ-485619 (7/21/2014)
I need some help in coding for a script task for a SSIS package.
I have a folder called TestFile in D:\, and I am placing a text 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)

July 21, 2014 at 11:11 am

#1731109
RE: Table Partiotion on Datetime column - nonclusterd index

Michael Valentine Jones (7/21/2014)
Minnu (7/21/2014)
Actually Performance is not a major issue in my case, trying to implement the table management.
i want to store the older records away by creating partitions.
my...
--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)

July 21, 2014 at 11:07 am

#1731106
RE: Row are vanished from Table suddenly in SQL 2008

pratiksawant28 (7/21/2014)
Currently no other users are using this DB and admin access are with me only.
While checking have found that the one of the stored procedure was executed for deletion,...
--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)

July 21, 2014 at 11:00 am

#1731099
RE: Generate script to restore log backups

As a bit of a sidebar, if the MSDB database is still intact, you can use the GUI to do file level restores (it's pretty smart and will even handle...
--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)

July 21, 2014 at 10:56 am

#1731097
RE: Generate script to restore log backups

Mani-584606 (7/18/2014)
I tried that but its not working.
I'm using Ola Hallengren's backup script which will put full, diff and log backups in different directories.
So, maybe, copy the DIFs 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)

July 21, 2014 at 10:49 am

#1731091
RE: Dynamic Audit

I'm not sure why people are so hepped-up on wanting to avoid triggers for such a thing. Written correctly, they're very targeted, very fast, require little special knowledge, 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)

July 21, 2014 at 9:19 am

#1731058
RE: Table Partiotion on Datetime column - nonclusterd index

Minnu (7/21/2014)
Select query is taking long time on this table, there are more than 10000 inserts per day.
and this table is mainly used for OLAP process only.
Finally...performance of table needs...
--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)

July 21, 2014 at 9:09 am

#1731056
RE: Error when selecting top N records from oracle

I'm also pretty sure that, even across a linked server, Oracle defaults to being case-sensitive for all things like table names, column names, etc, ad infinitum (just to cover 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)

July 21, 2014 at 9:02 am

#1731050
RE: format the output column in destination .csv

arkiboys (7/21/2014)
Hello,
in ssis, I use a oledb source to execute a stored procedure and a flat file source to have the result into .csv format file.
One of the result columns...
--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)

July 21, 2014 at 9:00 am

#1731049

Viewing 15 posts - 23,161 through 23,175 (of 59,102 total)