Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,386 through 17,400 (of 59,067 total)

RE: Rename file - prefix with file date

I don't know much about SSIS but it seems to me that the only way to process things in the correct order would be to "take control" of the situation....
--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)

June 25, 2016 at 1:45 pm

#1886918
RE: DevOps and Security

Personally, I think that any system that allows Developers to promote to prod or allows for unchecked code to be promoted automatically is just asking for trouble no matter 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)

June 25, 2016 at 1:08 pm

#1886915
RE: SQL Server 2016 is Out and It's Fabulous!

From the Article:
“This doesn’t work like it used to.”
While I agree that it probably has fewer bugs that previous releases, this one broke a whole lot of code where...
--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)

June 25, 2016 at 1:04 pm

#1886914
RE: Grouping mapping table records

alex.walmsley (6/23/2016)
Hi,
First question. Apologies for newbie errors.
I have a simple mapping table with related records like the following, just using IDs.
(IdA, IdB)
(1,1),
(1,2),
(2,2),
(2,3),
(3,4),
(4,4),
(4,5)
You can see the first 4 records are interlinked....
--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)

June 25, 2016 at 12:56 pm

#1886912
RE: RESTORE behavior with MOVE command

2josephpkeating (6/25/2016)
Running SQL Server 2014 SP1 on Windows 2012 R2
We do a lot of automated restores in lower environments from production every evening. The drive layouts vary from server 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)

June 25, 2016 at 12:45 pm

#1886911
RE: Need to remove an arrow char at end of each file as well as a trailing comma in header

Since Powershell is also "interpreted" rather than "compiled", I'm not sure that PowerShell would be any faster. Short of writing a compiled, automatic file editor (which could be incredibly...
--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)

June 25, 2016 at 12:34 pm

#1886910
RE: Tables, Primary Keys and Clustered Indexes

henrik staun poulsen (6/24/2016)
We have several tables above the 10 billion rows mark. Luckily we have the Enterprise Edition, so we have been able to partition the tables.
That helps maintainability,...
--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)

June 25, 2016 at 9:31 am

#1886894
RE: Practical Uses for Synonyms in SQL Server

Chris Harshman (6/24/2016)
bob.probst (9/11/2014)
I use synonyms to refer to any object outside of the database that I'm working in. They make for a useful way to encapsulate an...
--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)

June 25, 2016 at 8:59 am

#1886893
RE: Best way to filter columns

My first inclination would be to use the UNIQUEIDENTIFIER datatype for the GUID instead of VARCHAR but that may be contrary to formatting of the data received. If it's...
--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)

June 25, 2016 at 8:49 am

#1886892
RE: Performanence very slow after migrated database from 2000 to 2008 sql

solomon.jernas (6/24/2016)
Users are facing slowness issue after restored database from 2000 to 2008 sql server, they are gernerating report in crystal
it takes 5 minutes in SQL 2000 physical server....
--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)

June 24, 2016 at 5:09 pm

#1886870
RE: Best way to filter columns

On the serious side, how are these feeds stored in the staging table? VARCHAR, NVARCHAR, VARBINARY, XML or ???? Within that question, are they the MAX datatype? ...
--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)

June 24, 2016 at 5:05 pm

#1886869
RE: Best way to filter columns

frontrunner148 (6/23/2016)
I have been asked to exclude RSS items where words like Kardashian is in the description. What we would rather have are topics about disasters, terror, crime, politics, scandal.
Odd......
--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)

June 24, 2016 at 5:02 pm

#1886868
RE: Have You Designed a Database from Scratch?

WHUT!!??? Design a database??? Isn't that what ORM tools are for? :sick::-):-D:-P;-):hehe:
--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)

June 24, 2016 at 4:54 pm

#1886867
RE: Massive Performance Issues with on TempDB and SharePoint 2013

sith (6/22/2016)
... SharePoint Developer (with no SQL Skills).
Not quite on-subject but you have no idea how much I enjoyed that little bit of irony. 😀
--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)

June 24, 2016 at 4:52 pm

#1886866
RE: Concatenate strings

curious_sqldba (6/24/2016)
Jeff Moden (6/23/2016)
curious_sqldba (6/22/2016)
Sean Lange (6/22/2016)
curious_sqldba (6/22/2016)
Thanks. This is just displaying, i want to store the data in the variable and then use the variable different places.
Do you know...
--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)

June 24, 2016 at 4:46 pm

#1886865

Viewing 15 posts - 17,386 through 17,400 (of 59,067 total)