Viewing 15 posts - 35,536 through 35,550 (of 49,552 total)
oliver.morris (12/2/2009)
PS - I am not trying to change the stucture of the data but simply filter a UDF based on a sp.
Doesn't matter. For all SQL knows, that proc...
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
December 2, 2009 at 8:45 am
Turn it into a stored procedure?
UDFs are not allowed to have side-effects (ie they may not change the structure of the database). Since procedures can, it would seem that 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
December 2, 2009 at 8:19 am
muthukkumaran (12/2/2009)
Hi,Read & use the index de-fragmentation script added in my signature.
Why does your script use deprecated objects (that will be removed in future versions) and global temp tables?
Also, 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
December 2, 2009 at 7:59 am
Ali_SQLDBA (12/2/2009)
Most of my tables are either clusterd or non clustered.
Um, the distinction is clustered or heap. A nonclustered index is a separate structure and can sit on either...
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
December 2, 2009 at 7:57 am
Give it two schedules. Schedule 1 - Daily at 7am. Schedule 2 - Daily at 7pm.
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
December 2, 2009 at 7:23 am
luckysql.kinda (12/2/2009)
I want you to go ahead and remove the indexes which are referring LOB (text,ntext,image) and run rebuild again.
Why?
External fragmentation usually refers to file-level fragmentation that's fixed with 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
December 2, 2009 at 7:09 am
sqldba.jagan (12/2/2009)
The tables in the database has varied page count. I think I have very few pages >=10 - <=25 and their frag ranges from 87.5 - 33.33.
Don't even...
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
December 2, 2009 at 7:07 am
atramard (12/2/2009)
- you...
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
December 2, 2009 at 5:52 am
Paul_Harvey (12/2/2009)
I have noticed that making a field mandatory and unique appears to crate an index. Is this correct?
Making a field unique creates an index. The mandatory part has...
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
December 2, 2009 at 5:50 am
Expose the LUN to the cluster, create a disk resource for it in cluster admin, make that resource a dependency of the SQL Service that will be using it.
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
December 2, 2009 at 5:42 am
oliver.morris (12/2/2009)
OK I think I have tracke it down to refering to a table variable column as @tbl.column1why is it not possible to do this
Just the way the language works....
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
December 2, 2009 at 5:41 am
rahulsony111 (12/1/2009)
How can i specify the table name and column name.
Like this. As I said, look at the rest of the query where it is done properly
BEGIN
select 'alter table '...
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
December 2, 2009 at 12:15 am
Might be worth calling Microsoft's customer support on 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
December 2, 2009 at 12:15 am
Please read through this - Managing Transaction Logs[/url]
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
December 2, 2009 at 12:13 am
How big's the index? How many pages?
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
December 2, 2009 at 12:13 am
Viewing 15 posts - 35,536 through 35,550 (of 49,552 total)