Viewing 15 posts - 91 through 105 (of 309 total)
Lynn Pettis (5/7/2015)
New Born DBA (5/7/2015)
Sorry, but I actually spit soda out my nose on this comment:
Well I hope you are OK. 😀
It isn't a system field, the column c1is...
May 7, 2015 at 9:20 am
Sorry, but I actually spit soda out my nose on this comment:
Well I hope you are OK. 😀
It isn't a system field, the column c1is a user defined column on...
May 7, 2015 at 9:07 am
New Born DBA (5/6/2015)
My suggestion, if most of your SELECT queries read on column C6, is to change the primary key from a CLUSTERED index to a NONCLUSTERED index and...
May 7, 2015 at 8:45 am
My suggestion, if most of your SELECT queries read on column C6, is to change the primary key from a CLUSTERED index to a NONCLUSTERED index and then make the...
May 6, 2015 at 12:38 pm
So COL_CORE_Audit_Data is a view? Need to see the DDL for the view and the underlying tables and the indexes on the tables.
Index 1:CREATE NONCLUSTERED INDEX [I387_6_1] ON [dbo].[T387]
(
[C6]...
May 6, 2015 at 11:54 am
So COL_CORE_Audit_Data is a view? Need to see the DDL for the view and the underlying tables and the indexes on the tables.
Table:
CREATE TABLE [dbo].[T387](
[C1] [nvarchar](15) NOT NULL,
[C2] [nvarchar](254) NULL,
[C3]...
May 6, 2015 at 11:51 am
Lynn Pettis (5/6/2015)
New Born DBA (5/6/2015)
May 6, 2015 at 11:09 am
See the issue is that I don't even know why SQL Server uses this Index? This Index is useless in this situation because column C1 is ID column which is...
May 6, 2015 at 11:01 am
New Born DBA (5/6/2015)
Query returns all data modified in the past 31 days.
Without seeing the indexes defined on the table, not much more can be done.
Index Info.
/****** Object: Index...
May 6, 2015 at 10:29 am
Query returns all data modified in the past 31 days.
Without seeing the indexes defined on the table, not much more can be done.
Well the thing is this query uses this...
May 6, 2015 at 10:29 am
J Livingston SQL (5/6/2015)the last 31 days...?????
Yes
May 6, 2015 at 10:25 am
New Born DBA (5/6/2015)
Lynn Pettis (5/6/2015)
Looks like you are storing date information as seconds since midnight 1970-01-01, correct?
Yes, that is correct.
So, what is the where clause attempting to filter?
Sorry, but...
May 6, 2015 at 10:24 am
Lynn Pettis (5/6/2015)
Looks like you are storing date information as seconds since midnight 1970-01-01, correct?
Yes, that is correct.
So, what is the where clause attempting to filter?
Sorry, but I don't know.
May 6, 2015 at 10:05 am
Viewing 15 posts - 91 through 105 (of 309 total)