Viewing 15 posts - 466 through 480 (of 557 total)
And another alternative solution, based on 'strings'
declare @Month int = 2, @Year int = 2013
declare @ThisDate datetime = convert(varchar(8),@year*10000+@month*100+01)
select CONVERT(varchar(7),@thisdate,121)+'-01'
select CONVERT(varchar(7),dateadd(mm,1,@thisdate),121)+'-01'
ben brugman
February 26, 2013 at 5:09 am
GilaMonster (2/22/2013)
ben.brugman (2/22/2013)
GilaMonster (2/22/2013)
If the PLE is 400, then on average a page is expected to remain in cache for a total of 400 seconds. 400 seconds from the time...
February 22, 2013 at 11:31 am
GilaMonster (2/22/2013)
ie, if PLE is 400, then on average a page is expected to remain in cache for 400 seconds.
Is that from the moment we measure. Or from the moment...
February 22, 2013 at 11:07 am
Gazareth (2/22/2013)
ben.brugman (2/22/2013)
The average time a page remains in the cache is two times the time it has been in the cache at any moment.Is it?
Sorry but with any...
February 22, 2013 at 10:39 am
GilaMonster (2/22/2013)
PLE is a historical average of how long a page remained in cache after having been read in.
The average time a page remains in the cache is two...
February 22, 2013 at 10:05 am
Gazareth (2/22/2013)
I think you're looking at PLE from the wrong side - it's a measure of what has happened on your system, not what will happen.
The E stands for expectancy....
February 22, 2013 at 9:33 am
DECLARE @TODAY DATETIME = CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),126))
SELECT @TODAY
DECLARE @TOMORROW DATETIME = @TODAY+1
--
-- Alternative
-- DECLARE @TOMORROW DATETIME = DATEADD(DD,1,@TODAY)
-- DECLARE @TOMORROW DATETIME = DATEADD(HH,24,@TODAY)
--
SELECT @TOMORROW
SELECT * FROM TheTable WHERE TheDate >= @TODAY AND...
February 22, 2013 at 8:56 am
GilaMonster (2/15/2013)
the clustered index should be created with the UNIQUE keyword
Thanks, and yes this was clear to me from your posts.
Ben
February 18, 2013 at 3:07 am
GilaMonster (2/15/2013)
... ... UNIQUE ... ... (and identity column does not guarantee uniqueness).
Thanks, most or all other tables have the UNIQUE 'constraint', this table should have the UNIQUE constraint. Thanks...
February 15, 2013 at 8:17 am
ScottPletcher (1/31/2013)
January 31, 2013 at 10:05 am
ScottPletcher (1/29/2013)
You may or may not need partitioning.But you absolutely need to determine the proper clustered index for the table.
I totally agree that a clustered index will help performance in...
January 31, 2013 at 2:51 am
GilaMonster (1/29/2013)
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Thank you Gail for the link.
From the link:
'summary would be: don't change or implement anything without research and without knowing what it's going to affect. '
My quest at the...
January 31, 2013 at 2:07 am
siggemannen (1/28/2013)
INSERT INTO T(...)
SELECT t.a, t.b, 1
FROM sometable t
UNION
SELECT -t.a, t.b, 1
FROM sometable t
, both "sides" of union will retrieve...
January 29, 2013 at 10:02 am
GilaMonster (1/24/2013)
ben.brugman (1/24/2013)
I'd personally ignore PLE during CheckDB execution. Because it reads the entire database and because it marks pages brought in as 'disfavoured', meaning they'll be the first to...
January 24, 2013 at 9:52 am
Bhuvnesh (1/22/2013)
ben.brugman (1/22/2013)
Any suggestions how to catch the processes which cause the drop in PLE ?
it means you have buffer cache issue and IO contentions
see these links
http://sqlblog.com/blogs/buck_woody/archive/2010/06/29/the-windows-page-file-and-sql-server.aspx
http://support.microsoft.com/kb/889654/en-us
and...
January 24, 2013 at 8:51 am
Viewing 15 posts - 466 through 480 (of 557 total)