Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,231 through 22,245 (of 59,102 total)

RE: SQL2014RTM or SQL2014RTM+CU4

MS usually only supports migrations from 2 previous revs. Unless there's something desperately needed from 2014, you might want to consider migrating to 2012 just to make things a...
--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)

December 12, 2014 at 6:21 am

#1764384
RE: Backup Exec stomping on my SQL Server Backups

plamannkathy (12/12/2014)
Then I want to test, test, test recoverability.
Thanks
Kathy
+1000
--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)

December 12, 2014 at 6:17 am

#1764381
RE: The Last Job

The question from the article:
Is this the last full time, technology job you'll have?
Yes it is! I love what I do. Even though I'm at retirement age, I...
--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)

December 11, 2014 at 9:00 pm

#1764259
RE: Help with number / percentage format

Jason-299789 (12/4/2014)
Phil Parkin (12/4/2014)
Jason-299789 (12/4/2014)
IN SQL server if you do a divide an Integer by an integer you get an integer, and a count will only ever produce an integer....
--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)

December 11, 2014 at 7:01 pm

#1764256
RE: SELECT a String

Seems to be a correct answer, as well. If it's not, let them know on that other post.
--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)

December 11, 2014 at 6:59 pm

#1764255
RE: 42% of 100% taken in clustered index insert

Grant Fritchey (12/2/2014)
npranj (12/1/2014)
Thanks Grant.
The 42% cost is Clustered Index insert cost. There is one CI and 4 NCI on this table.
All the other costs are from Index Seeks.
Also,...
--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)

December 11, 2014 at 6:54 pm

#1764254
RE: growth above normal log database!

rmedeiros (12/11/2014)
Dear changed the log full bank for simple did shrink and it worked,
Thank you all for the help
AND??? You do realize that you need to at least do...
--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)

December 11, 2014 at 4:59 pm

#1764249
RE: Load Folder name and Images into SQL Tables

robertdba (12/11/2014)
Hello Jeff,
Sorry for the late reply, too much snow up here in Canada and network issues.
So I will test it now, but before I got a question for you....
--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)

December 11, 2014 at 11:39 am

#1764179
RE: Space Problems

M. Gamito (12/11/2014)
Jeff Moden (12/11/2014)
M. Gamito (12/11/2014)
Hello.
I'm having some problems with my database usage space.
I have a database with atogrowth off and limited size to 150GB.
When users try to import...
--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)

December 11, 2014 at 9:21 am

#1764134
RE: Space Problems

M. Gamito (12/11/2014)
Hello.
I'm having some problems with my database usage space.
I have a database with atogrowth off and limited size to 150GB.
When users try to import files, large databases 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)

December 11, 2014 at 8:06 am

#1764080
RE: Approaches for creating a test environment

TerrenceTheCat (12/11/2014)
Hi all,
I am try to put together options in regard to creating a test environment for our Dynamics NAV system. The environment will be mainly used to test new...
--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)

December 11, 2014 at 8:01 am

#1764075
RE: growth above normal log database!

Jason-299789 (12/11/2014)
Its not surprising if you are rebuilding the clustered index as well which will effectively rebuild the entire table via the TempDB, I'll take a stab in the dark...
--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)

December 11, 2014 at 7:50 am

#1764071
RE: get full path from sys.xp_dirtree

Still, it's a brilliantly simple solution and it does solve a very common problem without a trip to the Command Prompt. Well done, again!
And, yeah, I agree. How...
--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)

December 11, 2014 at 7:46 am

#1764070
RE: Cte for String in random order

Two way street here. I know it' been several months but I'm still interested in why you needed to do this.
--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)

December 10, 2014 at 11:59 pm

#1763954
RE: Trouble with SQL Timeouts

mqbk (12/10/2014)
I am having sporadic SQL timeout errors from on of my companies applications. The first time we have seen this was when our connections went over the default 100...
--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)

December 10, 2014 at 11:28 pm

#1763951

Viewing 15 posts - 22,231 through 22,245 (of 59,102 total)