Viewing 15 posts - 13,006 through 13,020 (of 49,552 total)
mahesh.shinde (5/26/2013)
Yes database which is residing on principle server. You've to take T-log backup multiple time to enable database for shrinking T-log file.
That's the principal database, not the mirror....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2013 at 7:41 am
No way to answer that question in general. Depends on what exactly you're doing.
If you are talking about a subquery in the from clause (derived table) and a join, then...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2013 at 7:39 am
mahesh.shinde (5/26/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2013 at 7:31 am
Without seeing the details and specifics of what the maint plan does, it's going to be near-impossible to answer this.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2013 at 4:39 am
If the table's empty, then yes you can probably change the data type. You will have to drop all indexes first and recreate them afterwards.
Improve performance, probably not.
Save space, if...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2013 at 4:09 am
Without seeing what the maintenance job does and why it's trying to delete statistics in the first place, no way to say.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2013 at 4:06 am
shohelr2003 (5/25/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2013 at 4:05 am
Loundy (5/25/2013)
wouldn't it also cause all values to round down? i.e 5.5 to 5, 6.1 to 6 etc....?
Decimal(18,0) doesn't allow values like 5.5 or 6.1, only whole numbers because the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2013 at 11:47 am
mpradeep23 (5/25/2013)
Decimal 9 bytes int 5 bytes it may reduce the size for that case i am thinking of it
Is the table so big that a 5-byte size reduction...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2013 at 10:52 am
EasyBoy (5/24/2013)
Run DBCC CHECKDB to check for any corruption.
And?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2013 at 4:31 am
Maybe, if the rebuild was recent enough.
Install logs do show the correct date, as in the date the install was done. Make sure you're looking at the right logs.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 1:37 pm
The file date stamps on some of the installation logs maybe. Look around near the location of the SQL binaries, sure to be an install log file somewhere around there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 1:24 pm
George Luiz (5/24/2013)
is it correct if I assume that SQL Server should have used my index and do an index seek instead of an index scan?
No.
To do an index...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 8:47 am
SELECT OBJECT_NAME(object_id) AS TableName, i.index_id, i.name, ds.name
FROM sys.indexes i INNER JOIN sys.data_spaces ds ON i.data_space_id = ds.data_space_id
The indexes and the filegroups they are on.
If an index is on a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 6:43 am
Sergiy (5/24/2013)
GilaMonster (5/24/2013)
I never claimed or stated anywhere that it has any effect on the insert
Look, just 1 row above you say:
the select portion of an insert statement
If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 6:40 am
Viewing 15 posts - 13,006 through 13,020 (of 49,552 total)