Viewing 15 posts - 1,861 through 1,875 (of 6,036 total)
Jayanth_Kurup (10/23/2015)
Mainly I think the reason this discussion is dragging on is because there is a misconception of how indexes work for OLTP system vs DW systems.
The main reason of...
October 23, 2015 at 3:29 am
Jayanth_Kurup (10/23/2015)
Big table resides in a single file
Are you sure?
with partitioning you can split a big table into many smaller files such that year 2010 data goes into...
October 23, 2015 at 2:59 am
xsevensinzx (10/22/2015)
October 22, 2015 at 6:16 pm
Jayanth_Kurup (10/22/2015)
here is the blog link with videohttp://enabledbusinesssolutions.com/blog/does-partitioning-improve-performance/
You're obviously not listening what people trying to tell you.
Your example repeats that very "junior mistake" I was talking about:
CLUSTERED INDEX ON...
October 22, 2015 at 4:01 pm
Jayanth_Kurup (10/22/2015)A DW doesn't perform seeks it performs scans ( nobody fetches only one months data from a DW, usually they aggregate over months , years and even decades some...
October 22, 2015 at 3:49 pm
Jayanth_Kurup (10/22/2015)
Partitioning can improve performance mainly in the following ways-For very large tables partition elimination does provide real benefits
With correctly chosen clustered index it does not matter how...
October 22, 2015 at 4:56 am
Kristen-173977 (10/20/2015)
Sergiy (10/19/2015)
Make sure you have a clustered index on "record date time" column.
I would only re-create a clustered index if there isn't one already - any existing clustered...
October 20, 2015 at 6:43 pm
Make sure you have a clustered index on "record date time" column.
Then selecting of a monthly range of records will work really fast, and the rest of conditions would...
October 19, 2015 at 8:36 pm
The thing is - the security risk coming from inappropriate setup of privileges for correlated accounts is there all the time, no matter if you're using xp_cmdshell or not.
Not using...
September 30, 2015 at 4:33 pm
Can you tell us more about those condition cond1, condtn you use in the query? How do they look like?
And I can see objectA mentioned 4 times in the query....
September 30, 2015 at 4:14 pm
SQL Server will always use all the memory you make accessible to it.
Unless you specifically enforce releasing previously cached pages.
Normally SQL Server will keep cached execution plans, data sets in...
September 23, 2015 at 8:19 am
...
left join objectA
on (worktbl.id = objectA.ID AnD worktbl.order >1000)
OR
(worktbl.anotherid = objectA.ID AnD worktbl.order =1000)
left join
....
Try to rewrite this join.
Using such constructions in joins, especially when OR is involved...
September 23, 2015 at 8:11 am
TheSQLGuru (8/18/2015)
IsNull(c.BeginBal,cast(0 as correctdatatype)) + IsNull(d.NetActivity,cast(0 as correctdatatyp)) As [Begin_Bal]
Or -
Declare @DecimalZero decimal (9,2)
SET @DecimalZero = 0
SELECT IsNull(c.BeginBal, @DecimalZero) + IsNull(d.NetActivity, @DecimalZero) As [Begin_Bal]
August 18, 2015 at 9:07 pm
And talking about resources.
From what you said - it must be the case of memory shortage/failure on the "slow" server.
Compare memory availability on each server, how much of it allocated...
August 18, 2015 at 9:01 pm
And talking about resources.
From what you said - it must be the case of memory shortage/failure on the "slow" server.
Compare memory availability on each server, how much of it allocated...
August 18, 2015 at 9:00 pm
Viewing 15 posts - 1,861 through 1,875 (of 6,036 total)