Viewing 15 posts - 39,946 through 39,960 (of 49,552 total)
Look up sp_executesql. It allows passing of parameters to and from dynamic SQL.
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
April 6, 2009 at 9:13 am
radek (4/6/2009)
BTW: Of course I know, if I have small table that it is not good to create index.. but i dont know that 20000 rows is too small 🙂
No,...
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
April 6, 2009 at 8:39 am
Krishna Potlakayala (4/6/2009)
In your script you should also include something like i think it is if the number of pages >2000 then you should consider rebuilding or defragging them.
1000, 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
April 6, 2009 at 8:14 am
I would suggest that you cast both columns to numeric before joining. That way trailing zeros will be completely ignored. This, of course, assumes that all values in the column...
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
April 6, 2009 at 8:08 am
Ramesh (4/6/2009)
Now, if I would have posted that question in SSC and I would be very un-happy:crazy: if I receive a response such as "No interview questions".
If you had asked...
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
April 6, 2009 at 7:51 am
waqarlaghari (4/6/2009)
In quries it uses both words "Left Outer Join" and "Outer Join". So i was confused.
In SQL Server it's not possible to have just OUTER JOIN specified. Doing...
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
April 6, 2009 at 7:24 am
Small indexes often don't rebuild properly. It's nothing to worry about, fragmentation isn't an issue on such small indexes.
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
April 6, 2009 at 7:08 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
April 6, 2009 at 6:38 am
2cams (4/6/2009)
*********UPDATE**********I restored the Distribution DB DANKIE TOG!!!!!
Dis 'n plesier.
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
April 6, 2009 at 6:08 am
Lowell (4/6/2009)
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
April 6, 2009 at 6:07 am
Dean Jones (4/6/2009)
With regards to [Using low transaction isolation levels]How can this be doen with Delete and Updates, i thought it was mainly reads.
Read uncommitted is only for selects (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
April 6, 2009 at 6:02 am
select 'insert into exportacao_diferenca values ('+CAST(codctb AS VARCHAR(10))+','''+nifctb+''')' from TABELA_AUXILIAR_COMPARACAO
May I ask what you're trying to achieve here? There are easier ways to insert the values from one table into...
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
April 6, 2009 at 3:22 am
2cams (4/6/2009)
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
April 6, 2009 at 3:14 am
2cams (4/6/2009)
I create a NEW TRACE FILE when the server was idling @ 100% activity :hehe:
Ran the tuning advisor and it recomended 2 non clustered indexes. 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
April 6, 2009 at 3:03 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic690756-148-1.aspx
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
April 6, 2009 at 1:03 am
Viewing 15 posts - 39,946 through 39,960 (of 49,552 total)