Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,316 through 21,330 (of 59,098 total)

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
RE: Nested Dateadd function for Date range.... any ideas?

shalaran (3/9/2015)
Hi,
I'm working on a tsql query to return a column with the summed time units for each week. However, I'm only getting a summed total at Week6, and am...
--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 9, 2015 at 9:53 pm

#1782763
RE: SQL Server Idle Time

NachiM (3/9/2015)
We got 10 SQL servers in production. Basically Data is sharded horizontally using custom coding into these servers. (System was architect-ed almost 10 years back and was build using...
--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 9, 2015 at 7:02 pm

#1782754
RE: Stored Proc hanging in SSIS, runs 20 secs in SSMS (2008 R2 SP1)

steven.oates (2/13/2015)
Hi,
We have a problem which we have hit a brick wall with, hopefully someone can offer some support or point us in the right direction...
We have an SSIS parent...
--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 9, 2015 at 6:41 pm

#1782752
RE: SP_Configure - Help!

smatu (3/9/2015)
Please Help!
My instance will not restart after I stopped it. I issued the command below inorder to enable backup of my databases to a mapped drive. Now 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)

March 9, 2015 at 5:34 pm

#1782742

Viewing 15 posts - 21,316 through 21,330 (of 59,098 total)