Viewing 15 posts - 9,721 through 9,735 (of 49,552 total)
Not without a lot more information.
Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/. What are its current performance statistics? What is the required duration?
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
March 12, 2014 at 3:22 am
Junglee_George (3/11/2014)
The guy who reviewed my code that there will be performance enhancement if I used this way.
Did he explain why he believes that?
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
March 12, 2014 at 3:20 am
yuvipoy (3/12/2014)
only thing is database is set as Simple mode is this a problem ?
No
If i switch to Full mode will it solve.
No.
The index rebuild is running out of...
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
March 12, 2014 at 2:52 am
If you want the nitty-gritty technical details, google for NUMA SQL Server, there should be a few white papers available which discuss how SQL handles a NUMA architecture (which is...
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
March 12, 2014 at 2:24 am
Play around with sys.dm_exec_query_stats for all of those and be aware that you may well not be getting the full picture.
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
March 12, 2014 at 2:21 am
prettsons (3/12/2014)
You need to remove the suspect mode from the server first then you can attach the database.
No.
Suspect is a status that a database has, not a server and it's...
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
March 12, 2014 at 2:20 am
Not without a constantly running trace/extended events session and very hard even with that (views are used as part of other statements, not alone)
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
March 12, 2014 at 2:16 am
The error is complaining that the database is too small. Shrinking it (making it smaller) is not the solution, it's the complete opposite of the solution. You need to grow...
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
March 12, 2014 at 2:14 am
Ask your ISP what they did. Sounds like backups were restored of the databases or the entire machine or the system was reverted to an earlier savepoint.
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
March 12, 2014 at 2:13 am
You'll have to implement a custom trigger and an auditing table to track the updates if you want this information. It isn't tracked by default.
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
March 12, 2014 at 2:11 am
Koen Verbeeck (3/11/2014)
Grant Fritchey (3/11/2014)
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
March 11, 2014 at 7:51 am
Goes back to the question, do you have a performance problem? If not and this is an existing table, leave it alone. If no and this is a new 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
March 11, 2014 at 7:36 am
yuvipoy (3/11/2014)
I am just asking will there be inprovement if there the data type is Int
Improvement over what?
If i am going to design new table how can i go...
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
March 11, 2014 at 7:25 am
Take a read through this: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
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
March 11, 2014 at 7:05 am
???
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
March 11, 2014 at 5:56 am
Viewing 15 posts - 9,721 through 9,735 (of 49,552 total)