Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,416 through 17,430 (of 59,102 total)

RE: Sql Duplicate Values

Apparently, the data quality of the XML you've been provided to work with is at an all time low. It seems to indicate the company has no clue 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 26, 2016 at 8:43 pm

#1886955
RE: Rebuilding Indexes

jayoub (6/26/2016)
Q: Why is it that when there is only one table in the database there are a few hundred statistics listed (is it because I am also seeing statistics...
--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 26, 2016 at 8:26 pm

#1886954
RE: CPU Usage 100%

jayoub (6/26/2016)
I sometimes find one of my SQL server CPU usage pegged at 100% and I don’t know what to do to stop it. When I use Perfmon or...
--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 26, 2016 at 8:15 pm

#1886951
RE: Querying XML

I got this right "just" by deduction (I don't use or work with XML) but, my word, let's add to the list of reasons why I hate XML, shall we?...
--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 2:56 pm

#1886922
RE: Clustering with problem database

One of the easiest and fastest ways to clear all connections to a database is to use the following code (change the DB name, of course)... read the comments...
--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 2:27 pm

#1886920
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

Viewing 15 posts - 17,416 through 17,430 (of 59,102 total)