I just was making some performance tests with some batches going one by one, that was returning only times of durations. At start of every batch I called statements for cold start, so - in result - it added doubled

DBCC exe...
                        

I just was making some performance tests with some batches going one by one, that was returning only times of durations. At start of every batch I called statements for cold start, so - in result - it added doubled

DBCC exe...
                        

I just was making some performance tests with some batches going one by one, that was returning only times of durations. At start of every batch I called statements for cold start, so - in result - it added doubled

DBCC exe...
                        

I just was making some performance tests with some batches going one by one, that was returning only times of durations. At start of every batch I called statements for cold start, so - in result - it added doubled

DBCC exe...
                        

EXEC sp_MSForEachTable 'TRUNCATE TABLE ?' Instead of ? you can place a name of table.......

EXEC sp_MSForEachTable 'TRUNCATE TABLE ?' Instead of ? you can place a name of table.......

I did not expect the following code to run: (((((((SELECT * FROM sys.objects WHERE type = 'U'))))))) But it does, just fine. I believed that parentheses were only an *expressive* construct and never a *procedural* one. I'm quite familiar with deri...

I did not expect the following code to run: (((((((SELECT * FROM sys.objects WHERE type = 'U'))))))) But it does, just fine. I believed that parentheses were only an *expressive* construct and could never stand in place of a *procedur...

I'm new here, so I apologize for duplicating any previous posts. :) This is just one of the more obscure tips I've learned and wanted to share. Thanks for the comments, everyone. And Joe, thanks for the specific clarification. (Love your Smarties boo...

I'm new here, so I apologize for duplicating any previous posts. :) This is just one of the more obscure tips I've learned and wanted to share. Thanks for the comments, everyone. And Joe, thanks for the specific clarification. (Love your Smarties boo...