Jeff Moden

Forum Replies Created

Viewing 15 posts - 28,081 through 28,095 (of 59,101 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (11/24/2012)
... and Jeff's attempt to get the thread into a serious discussion :w00t:
Heh... yeah. Totally misplaced attempt. Wrong place. 😛
--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)

November 25, 2012 at 7:41 am

#1562043
RE: SSD Lifetimes

FusionIO has listed 2 million hours and 6 years write endurance for their cards, ...
Perhaps I'm reading something wrong but 6 years is only about 52,596 hours. 2 Million...
--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)

November 25, 2012 at 7:27 am

#1562042
RE: SSD Lifetimes

Michael Valentine Jones (11/24/2012)
The 400 GB drive on this link is rated a 35 PB of lifetime writes, so that would mean you could write 1 TB of data on...
--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)

November 25, 2012 at 7:20 am

#1562041
RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

opc.three (11/24/2012)
It's quite possible that leaving the FILLFACTOR at 100 would make the most sense. With the SSD in play, the page splits and ensuing fragmentation may be less of...
--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)

November 25, 2012 at 7:04 am

#1562040
RE: how to write a stored procedure to check if the members membership has expired

Vedran Kesegic (11/24/2012)
It has much better performance than a procedure, but if you must use a procedure you can use the same expression used in a vew.
You know, of course,...
--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)

November 25, 2012 at 6:51 am

#1562039
RE: Reads too high on indexed-table update

SpringTownDBA (11/24/2012)
I would guess that being a heap is making the difference. I haven't fired up my work laptop yet this weekend, but some agent alerts hitting my phone...
--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)

November 24, 2012 at 4:51 pm

#1562007
RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

Wouldn't it just be easier and safer to set the FILL FACTOR appropriately and make sure that reindexing was occuring on a regular basis? That would't require any code...
--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)

November 24, 2012 at 4:32 pm

#1562005
RE: backup file growth and disk size-SQL 2005 database

Sqlsavy (11/23/2012)
Hi All,
We use Litespeed to backup our databases. One particular database grows 330MB/day there is enough space on the data and log drives but I think backup drive will...
--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)

November 24, 2012 at 4:25 pm

#1562004
RE: how to write a stored procedure to check if the members membership has expired

This is a duplicate post. Please, no answers here. Instead, please see http://www.sqlservercentral.com/Forums/Topic1388300-391-1.aspx
--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)

November 24, 2012 at 4:17 pm

#1562003
RE: how to write a stored procedure to check if the members membership has expired

sanjay.dakolia (11/24/2012)
i have a table named users where i have two three column userid, email, membershipexpiry
i want to write a stored procedure tat will take email as a input 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)

November 24, 2012 at 3:08 pm

#1562002
RE: how to write a stored procedure to check if the members membership has expired

jameslester78 (11/24/2012)
create database example
GO
USE example
GO
Create table tbl_a (email varchar (20),membershipexpiry date)
insert into tbl_a VALUES
('a@a.com','01-Jan-2012'),('b@a.com','01-Jan-2013')
GO
Create proc proc_a
@email varchar(20)
as
declare @v-2 date =
(select membershipexpiry from tbl_a where email = @email)
if @v-2<GETDATE() select 1...
--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)

November 24, 2012 at 2:58 pm

#1562000
RE: how to write a stored procedure to check if the members membership has expired

sanjay.dakolia (11/24/2012)
i have a table named users where i have two three column userid, email, membershipexpiry
i want to write a stored procedure tat will take email as a input 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)

November 24, 2012 at 2:47 pm

#1561999
RE: Reading from a New table

Even easier... use MERGE and migrate everything from the old table to the new table so you do't have to do this check for future inserts, etc.
--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)

November 24, 2012 at 2:37 pm

#1561998
RE: Help with replace parameter

We store the SSIS stuff on the SSIS box and the entire box gets replicated to the DR site through SAN replication. Makes life real easy and the DR...
--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)

November 24, 2012 at 2:35 pm

#1561997
RE: Lots of Key Lookups vs. UniqueIdentifier Clustered Index

opc.three (11/24/2012)
However the OP is talking about producing their own function to generate sequential GUIDs that would not be affected by a restart. The tradeoff of course is that all...
--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)

November 24, 2012 at 2:30 pm

#1561996

Viewing 15 posts - 28,081 through 28,095 (of 59,101 total)