Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,271 through 21,285 (of 59,072 total)

RE: Need help with processing cube

mtelena22 (3/14/2015)
Hi everyone!
I badly need your help, please. I have an SQL Server 2014 professional and Visual Studio 2012 installed. When I'm trying to process a cube it's an error...
--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 14, 2015 at 11:34 am

#1784043
RE: Copy varchar(max) fields slow

What are the initial size and growth settings for the DB and the related log file?
--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 14, 2015 at 11:28 am

#1784041
RE: Try It

+ 1 Billion, Grant.
What's really disconcerting is when I see the same people posting the nearly identical questions. "Trying it" is one of the best ways to learn... and...
--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 14, 2015 at 11:21 am

#1784039
RE: How to Prepare for Sql Server DBA Interview

surajghag123 (3/14/2015)
Hi everyone,
Can somebody help me or advice me on how to prepare for sql server dba interviews, i am currently working in [font="Arial Black"]support profile [/font]and preparing myself 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 14, 2015 at 11:13 am

#1784038
RE: Trigger for updates on a row using previous record value?

Enjoy_SQL (3/13/2015)
I ended up creating a view using similar logic to MMartins1, then build a trigger on the main table to reference the view. It works nicely. 🙂
Thanks everyone 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 14, 2015 at 10:59 am

#1784037
RE: Trigger for updates on a row using previous record value?

CELKO (3/11/2015)
>> I appreciate the quick response. Apologies, I am new to the forum .. I will try to clarify. <<
Thanks for trying, but you have not learned basic data modeling...
--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 14, 2015 at 10:56 am

#1784036
RE: Count number of backup files are deleted from a default backup location

To be honest, I wouldn't use the DOS "loop" to do the deletes. I'd import the results of a DIR into a table and parse the row information and...
--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 14, 2015 at 10:17 am

#1784034
RE: delete data from partitions - faster approach

Greg Robidoux has a short article on the subject. The keyword in SQL Server is "Switch". You might also want to look that word and the phrase "partitioned...
--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 14, 2015 at 10:14 am

#1784033
RE: Add 15 minutes to a time in char format

CELKO (3/12/2015)
CREATE TABLE Timeslots
(slot_start_time TIME(1) NOT NULL PRIMARY KEY,
slot_end_time TIME(1) NOT NULL,
CHECK (start_time < end_time));
INSERT INTO Timeslots --15 min intervals
VALUES ('00:00:00.0', '00:14:59.9'),
('00:15:00.0', '00:29:59.9'),
('00:30:00.0', '00:44:59.9'),
('00:45:00.0', '01:00:59.9'),
..
('23:45:00.0',...
--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 13, 2015 at 2:13 pm

#1783988
RE: Setting Different Colors for Connections in SSMS

Jeff Moden (3/13/2015)
Carl Neirynck (3/13/2015)
!!! Be aware that this ONLY works if you open a query window via Registered Servers!!!
So if you connect to a server/instance through the Object Explorer...
--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 13, 2015 at 8:56 am

#1783911
RE: Setting Different Colors for Connections in SSMS

Carl Neirynck (3/13/2015)
!!! Be aware that this ONLY works if you open a query window via Registered Servers!!!
So if you connect to a server/instance through the Object Explorer or when...
--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 13, 2015 at 8:51 am

#1783908
RE: The Worst Comments

Gary Varga (3/13/2015)
I was going to try and say "no comment" in a witty way but as I am not first to highlight the issue (and I am not always...
--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 13, 2015 at 6:20 am

#1783840
RE: Data Breach Danger

The thing that absolutely pisses me off about all of this is the cavalier attitude that many companies have about their data. I regularly see posts that obviously come...
--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 12, 2015 at 11:56 am

#1783680
RE: De-identification of Fields

g.britton (3/12/2015)
What does this mean: "de-identification of specific fields"
perhaps if you post some sample data and required results, we can help.
Obfuscation of personally identifiable information, I believe...
--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 12, 2015 at 11:36 am

#1783672
RE: Share your best possible answers--

Koen Verbeeck (3/12/2015)
Alvin Ramard (3/12/2015)
Seems to be a trend to use color that are not best for contrast. It's more common on web pages. My pet peeve? Why...
--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 12, 2015 at 10:22 am

#1783638

Viewing 15 posts - 21,271 through 21,285 (of 59,072 total)