Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,426 through 13,440 (of 59,101 total)

RE: Looking for an optimal solution

flownominal16 - Tuesday, December 12, 2017 1:12 PM
Preface:
I've been working on a particular problem past the threshold of time before I should...
--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 13, 2017 at 11:12 am

#1971999
RE: SQL Restore takes long time - how do I clear committed transactions from log ?

Gamleur84 - Thursday, December 7, 2017 11:50 AM
I am not concerned about the 500GB empty file.
You should be. Even with a log...
--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 13, 2017 at 11:04 am

#1971998
RE: Missing index question

Grant Fritchey - Wednesday, December 13, 2017 2:24 AM
A GIANT pinch of salt. The missing index DMVs do not relate the suggested...
--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 13, 2017 at 6:47 am

#1971943
RE: Reorganise indexes

Kris-155042 - Tuesday, December 12, 2017 9:57 PM
HI,
I got this from the ola.hallengren web site and when I run it, it doesn't appear...
--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 13, 2017 at 6:41 am

#1971941
RE: PRIME NUMBERS

Thank you both for the feedback.
--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 13, 2017 at 6:08 am

#1971935
RE: Advice for Newcomers

xsevensinzx - Wednesday, December 13, 2017 5:45 AM
Be a team player. Many will tell you to surround yourself with smart people; toss...
--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 13, 2017 at 6:05 am

#1971934
RE: PRIME NUMBERS

TheCTEGuy - Tuesday, December 12, 2017 6:13 AM
USE test;
GO
/*Tally table is the table with single column having no.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)

December 13, 2017 at 5:47 am

#1971930
RE: PRIME NUMBERS

unas_sasing - Tuesday, December 12, 2017 7:54 PM
Hai all,
thank you for helping me,
Yes I would like to reverse from a result set 2,3,5,7,11,13,17,19,23,29,...
--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 13, 2017 at 5:27 am

#1971927
RE: Quick and Dirty DR Solution Using Robocopy

barettojames99 - Tuesday, December 12, 2017 9:50 AM
There are too many things to take into consideration while working with robocopy and in...
--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, 2017 at 5:23 pm

#1971871
RE: Find and count Incomplete records in a table

eyejay - Tuesday, December 12, 2017 10:41 AM
Hi Jeff,
Many thanks for "shifting gears". Your tweaking of Steve's original solution is very useful....
--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, 2017 at 5:20 pm

#1971868
RE: Tempdb

giri10488 - Tuesday, December 12, 2017 4:20 PM
But it happens with me i have done on so many servers & resolve 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)

December 12, 2017 at 5:14 pm

#1971867
RE: PRIME NUMBERS

unas_sasing - Tuesday, December 12, 2017 4:32 AM
Dear all,
I have SP :

CREATE proc [dbo].[usp_FindPrimes] (@opt tinyint, @ResultCount int)
as
set ROWCOUNT ...
--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, 2017 at 3:56 pm

#1971858
RE: How to Automate the closing of a window?

sqlnoob2015 - Monday, December 11, 2017 12:36 PM
What is the best way to automate the clearing out of an error message that...
--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, 2017 at 3:00 pm

#1971845
RE: Advice for Newcomers

Alan.B - Tuesday, December 12, 2017 1:51 PM
Do what you love and the money will come; nobody is awesome at stuff they...
--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, 2017 at 2:44 pm

#1971841
RE: Advice for Newcomers

drew.allen - Tuesday, December 12, 2017 12:44 PM
Jeff Moden - Tuesday, December 12, 2017 12:41 PM
--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, 2017 at 1:46 pm

#1971837

Viewing 15 posts - 13,426 through 13,440 (of 59,101 total)