Jeff Moden

Forum Replies Created

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

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
RE: What Is the Hardest Feature to Learn About SQL Server?

I think that the hardest thing (a hidden feature, for sure) for people in general to learn about SQL Server is the paradigm shift necessary to produce high performance 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)

July 21, 2014 at 8:58 am

#1731047
RE: What Is the Hardest Feature to Learn About SQL Server?

andrew gothard (7/18/2014)
Off the top of my head, probably recursive CTE.
Recursive processes in POSH, .Net or VBS - say to explore a directory structure - clear as a bell. ...
--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 8:52 am

#1731045
RE: How can we DBAs get alerts when SQL resources don't come online after a cluster failover ?

Joy Smith San (7/21/2014)
Hi Thanks.
I was talking about only SQL Server services. Yes, I stumbled upon PowerShell script.
Anyone has any such script already running by any chance ?
Thanks again.
Smith.
Can...
--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 8:47 am

#1731042

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