Viewing 15 posts - 1 through 15 (of 23 total)
Hello John,
Just to make sure that I understand.
Shrink is just used to "shrink" the file size. The deleted rows (or the space they took) will be available without...
October 19, 2017 at 5:10 am
The problem I was anticipating was indexing and default value. But I guess that's not a problem...
Thanks for your answer!
August 29, 2017 at 6:07 am
So, name the table something else and fix it. Create a view with...
April 5, 2017 at 12:44 pm
April 5, 2017 at 12:47 am
Here is some more information.
The data is used for creating a marking of a product. There already is a database and we now need to add an identification of...
April 5, 2017 at 12:35 am
That is a good idea!
There is a lot of changes I need to do to make this work "perfectly"
Thanks for the suggestion!
March 15, 2017 at 10:53 am
OK. So the file is called a script and can contain multiple queries!
Thanks!
March 14, 2017 at 8:14 am
Although you have answered my question, I will try to explain why I ask.
As I said there is a SQL Query that contains all the changes to the...
March 14, 2017 at 7:17 am
Eirikur Eiriksson (11/22/2016)
andis59 (11/21/2016)
BTW, does the size of the database table has any impact on the Tuning Advisor and the time it takes to finish?
Quick advice, very carefully assess the...
November 22, 2016 at 9:41 am
Thank you Luis.
I realize that I have a long way to go in the world of SQL.
// Anders
November 22, 2016 at 8:27 am
MMartin1 (11/21/2016)
Here too is a resource that can help you get started with graphical execution plans : https://www.mssqltips.com/sqlservertip/1873/how-to-read-sql-server-graphical-query-execution-plans/
Looks like a good place to start!
November 21, 2016 at 2:41 pm
IF EXISTS( SELECT 1
FROM #serialno
HAVING Max(rowcreateddt)...
November 21, 2016 at 2:40 pm
Thanks Luis!
Looking forward to reading it!
November 21, 2016 at 1:02 pm
MMartin1 (11/21/2016)
The MAX(rowCreatedDT) is only scanning the table once!
There is a button in your SSMS window that displays "include actual execution plan" when you hover over it. You push this...
November 21, 2016 at 12:45 pm
Viewing 15 posts - 1 through 15 (of 23 total)