Viewing 15 posts - 26,551 through 26,565 (of 49,552 total)
Phil Nicholas (4/23/2011)
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 23, 2011 at 12:52 pm
Or, since sp_attach_db is deprecated on SQL 2005, CREATE DATABASE ... FOR ATTACH
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 23, 2011 at 11:00 am
Did you try google?
Temp tables and table variables are actual tables, both in TempDB
CTE and derived tables are both named resultsets used in queries, they're not (necessarily) stored in TempDB,...
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 23, 2011 at 10:53 am
crainlee2 (4/23/2011)
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 23, 2011 at 9:14 am
Syed Jahanzaib Bin hassan (4/22/2011)
If you are using SSMS query analyzer then this will not come you can manage this also inSSMS->Tools->Option->Query Execution
That affects only queries run from Management Studio,...
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 23, 2011 at 8:02 am
Syed Jahanzaib Bin hassan (4/22/2011)
2-You have define Max Degree of Parallelism to 8,This will define as 2 because its depend on physical processor not on logical
Max degree of parallelism affects...
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 23, 2011 at 7:59 am
Jack Corbett (4/23/2011)
So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
Want to swap? I'm having some amusement with someone who...
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 23, 2011 at 7:58 am
Syed Jahanzaib Bin hassan (4/23/2011)
you can define REMOTE QUERY TIME OUT and REMOTE LOGIN TIME OUT in SQL Server
Which are used when SQL runs a remote query, eg. OPENQUERY, OPENROWSET,...
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 23, 2011 at 4:20 am
I suspect the problem is that the queries in SQL are inefficient and are causing the application to time out. Maybe time for some optimisation.
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 22, 2011 at 2:33 pm
[Jim].[dba].[Murphy] (4/22/2011)
The reason you want them to not even read is probably because there is sensitive information in there.
And even if you do grant them just view definition...
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 22, 2011 at 2:30 pm
sandyinfowave (4/22/2011)
SQL Server Parse and Compile Time decrease significantly....So it looks like the creation of non clustered index on cln_serviceInstPayer did improve the performance
Parse and compile time will not be...
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 22, 2011 at 2:25 pm
With no IT experience, it's not likely you'll be able to land a DBA job. Developer, maybe.
http://www.brentozar.com/becoming-a-dba/how-to-get-a-junior-dba-job/
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 22, 2011 at 2:24 pm
Please don't cross post.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1097629-1292-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 22, 2011 at 2:23 pm
GilaMonster (4/22/2011)
Please post table and index definitions
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 22, 2011 at 2:21 pm
There are log reader tools, they may or may not work in this case (more likely won't if there has never ever been a backup) and the cost around $1000.
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 22, 2011 at 2:17 pm
Viewing 15 posts - 26,551 through 26,565 (of 49,552 total)