Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,286 through 21,300 (of 59,072 total)

RE: Share your best possible answers--

below86 (3/12/2015)
Jeff Moden (2/19/2015)
The correction I would make is that the sources that you mention aren't what I'd call "heterogeneous". The sources that you mention are very specific 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)

March 12, 2015 at 10:21 am

#1783637
RE: SQL Server Idle Time

One of the things I have running is a PerfMon that takes a sample every 15 minutes. I use PerfMon because I'm still currently stuck in the world 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)

March 11, 2015 at 8:00 pm

#1783507
RE: status suspended on command Killed/RolleBack

smoham22 (3/4/2015)
Its a scrubbing job. it takes a backup from production and restores it on development server and scrubs out the sensitive data for development.
spid went away after 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)

March 11, 2015 at 7:51 pm

#1783505
RE: Share your best possible answers--

Luis Cazares (2/26/2015)
Jeff Moden (2/26/2015)
Moin Ul Haque (2/26/2015)
Jeff Moden (2/25/2015)
Moin Ul Haque (2/25/2015)
I can quote my own experience here - Out of need, I was asked to develop a database...
--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)

March 11, 2015 at 7:46 pm

#1783504
RE: Help with Data type and size of the each row!!!!!!

Tac11 (3/9/2015)
Hi Jeff,
Since BLOBs live in different table, if I want to know 'what's the size of each row?' does the 'Data' contains (from sp_spacesued 'tablename') BLOBs too? And 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)

March 11, 2015 at 7:13 pm

#1783500
RE: Help in script task

I have to ask... why are you trying to do this to begin with? What is it that you're actually trying to do with the .BAK files?
--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)

March 11, 2015 at 7:09 pm

#1783498
RE: Flip data in SQL

Correct but I do have to thank you for taking the time to amplify your answer. Well done.
--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)

March 11, 2015 at 6:58 pm

#1783497
RE: Export Fixed Width

Apologies for the very late reply.
To the best of my knowledge, ragged right doesn't add a space or any such thing but I question the use of ragged right 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)

March 11, 2015 at 6:55 pm

#1783495
RE: Eliminating Cursors

PHYData DBA (2/26/2015)
Mark Hickin (1/17/2006)
I think it's worth making the point that this approach does nothing to combat what is fundamentally bad about cursors. All we have done here 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)

March 11, 2015 at 6:48 pm

#1783493
RE: Database File Placement and number of files

HookSqlDba7 (3/11/2015)
Thanks for all the responses. To clarify the statement, "We are planning to implement a new SQL Server 2014 OLTP Database with a 1 TB Data file and 1...
--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)

March 11, 2015 at 6:29 pm

#1783488
RE: Cannot create an instance of OLE DB provider "MICROSOFT.ACE.OLEDB.12.0" for linked server "(null)".

Andrew Pankov (3/2/2015)
Hi Jeff, thank you for response.
I tried OPENDATASOURCE instead of OPENROWSET.
SELECT * FROM OPENDATASOURCE ('Microsoft.ACE.OLEDB.12.0', 'Data Source=\\server\share\filename.xls;Extended Properties="Excel 12.0;IMEX=1;HDR=NO;"')...['2014$']
It's running ok again when sql server 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)

March 11, 2015 at 5:56 pm

#1783483
RE: How to Write Pivot Statement

See the following article:
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

March 11, 2015 at 4:47 pm

#1783468
RE: How to Remove Special Characters except Space

suresh0534 (3/9/2015)
Hi,
I got the Solution.
Below is the Solution.
DECLARE @str VARCHAR(400)
--Add your specialcharacters here
DECLARE @specialchars VARCHAR(50) = '%[~,@,#,$,%,&,*,(,),.,!^?:]%'
SET @str = 'KRA!NTHI@#KUMAR, KU%^?MAR GO~()$U.:D'
WHILE PATINDEX( @specialchars, @str ) > 0
---Remove special...
--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)

March 10, 2015 at 6:23 pm

#1783108
RE: EXCEL HELL!!!

Gosta Munktell (3/10/2015)
Jeff
I apologize for the too short and provocative statements.
On that subject, you're a good man for coming back on that. Thanks a huge amount, Gosta.
--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)

March 10, 2015 at 8:11 am

#1782927
RE: EXCEL HELL!!!

Thanks for your efforts, Gosta. I really appreciate it.
If we take a look at the following section of the code...
cmd.CommandText = " CREATE TABLE [dbo].[Test]( " & _
"[Name]...
--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)

March 10, 2015 at 8:09 am

#1782925

Viewing 15 posts - 21,286 through 21,300 (of 59,072 total)