Viewing 15 posts - 9,721 through 9,735 (of 49,571 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?
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?
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...
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...
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.
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...
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)
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...
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.
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.
March 12, 2014 at 2:11 am
Koen Verbeeck (3/11/2014)
Grant Fritchey (3/11/2014)
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,...
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...
March 11, 2014 at 7:25 am
Take a read through this: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
March 11, 2014 at 7:05 am
Viewing 15 posts - 9,721 through 9,735 (of 49,571 total)