Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,306 through 19,320 (of 59,072 total)

RE: Query on a large database

Jayanth_Kurup (10/27/2015)
Updated , cleaned up scripts attached.
I have written it so that you can simply copy paste and execute ( after reviewing the code ie).
I'm guessing that you didn't actually...
--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)

October 31, 2015 at 8:39 pm

#1836906
RE: What can I do to speed up my production daily full-backup?

Kristen-173977 (10/30/2015)
Jeff Moden (10/29/2015)
I've got a major table that contains call recordings divyed up like that (almost 400 gb) and I have one filegroup and file per month. Once...
--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)

October 31, 2015 at 7:13 pm

#1836902
RE: If statement in WHERE clause of Stored Procedure

childhood (10/31/2015)
The near same "hydera" but I have 2 variables varCategory, varName and I need condition AND beetween
varCategory AND varName below:
declare @varCategory int
declare @varName varchar(50)
Select * from tblparticipants
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)

October 31, 2015 at 4:34 pm

#1836894
RE: Are the posted questions getting worse?

Ed Wagner (10/30/2015)[hrSean, whatever you do, don't smoke the whole hog and then try to harvest pork chops from it. They'll be way to tender and won't have 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)

October 31, 2015 at 4:19 pm

#1836893
RE: SQL Injection - The Revenge

Heh... ok... without naming names.
I consulted for one company to help them with their performance problems. In the process, I ran across a table with SSN in plain text....
--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)

October 31, 2015 at 3:28 pm

#1836887
RE: How to format data in a grid view (pivot?)

Luis Cazares (10/30/2015)
I'm not sure what you mean. What would be the problem?
INSERT INTO #TempTable(StringColumn) VALUES( @StringVariable);
--OR
INSERT INTO #TempTable(StringColumn) SELECT @StringVariable;
You mean other than the fact that they're both RBAR???...
--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)

October 31, 2015 at 3:11 pm

#1836882
RE: Deadlocks in Partitioned Tables in Sql2012

We'd only be guessing without seeing the deadlock graph and the DDL for both tables including any indexes you may have on the tables. Post those and someone might...
--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)

October 31, 2015 at 11:11 am

#1836871
RE: Shocked. (A Halloween Horror story.)

To be honest, I'd say the quote about "half full" is incorrect, at least about the implementation for Microsoft's interpretation of the Rushmore Engine (the basis of SQL 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)

October 31, 2015 at 10:50 am

#1836870
RE: Better way of finding date?

Just another country heard from... this one returns a DATETIME datatype and works in all versions of SQL Server.
DECLARE @StartDate DATE = '01/01/2015';
SELECT DATEADD(yy,YEAR(@StartDate)-1901,'19001106');
I still like Luis'...
--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)

October 30, 2015 at 6:11 pm

#1836849
RE: Year over year reports

greenandgold52 (10/30/2015)
I have a year over year running total sales report that works perfect except for if a branch has not been open for two years. For branches 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)

October 30, 2015 at 5:42 pm

#1836848
RE: Tricky sql join

Your result doesn't appear to match your data but a FULL JOIN (a type of OUTER join) is what you want. Like this...
SELECT m.*, o.*
FROM...
--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)

October 30, 2015 at 5:40 pm

#1836847
RE: Ophaned index

Steve Hurst (10/29/2015)
I have an entry in the system.indexes table for an index that no longer exists on the table. How can I remove this?
How have you determined that 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)

October 29, 2015 at 11:51 pm

#1836572
RE: What can I do to speed up my production daily full-backup?

Jayanth_Kurup (10/29/2015)
http://blogs.msdn.com/b/sqlcat/archive/2008/03/02/backup-more-than-1gb-per-second-using-sql2008-backup-compression.aspx
Interesting read
What's "interesting" is that it would appear (I may have misread it) that they're putting the backups on the same system as the database and that would not...
--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)

October 29, 2015 at 6:20 pm

#1836558
RE: group by continual

SeeknFind (10/29/2015)
You are right to assume I have an older version (2005 🙁 ). However, I guess I was too short in my sample as this is not 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)

October 29, 2015 at 6:05 pm

#1836556
RE: What can I do to speed up my production daily full-backup?

Eric M Russell (10/29/2015)
Some audit tables are WORN (Write Once - Read Never).
Heh... appropriate, since we just got done talking about clean laundry. 😀
--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)

October 29, 2015 at 12:51 pm

#1836492

Viewing 15 posts - 19,306 through 19,320 (of 59,072 total)