Viewing 15 posts - 46 through 60 (of 454 total)
Thanks all for valuable replies. I modified the query in this way:
SELECT --t.object_id,
s.name,
t.name,
a.name,
sp.last_updated,
sp.modification_counter,
sp.rows,
...
December 14, 2017 at 7:57 am
Thanks, Sue for pointing to a sys.system_internals_partition_columns but unfortunately its modified_count does not reset after I run UPDATE STATISTICS. Besides, it is selecting much slower than outgoing sys.sysindexes.
Paul in his...
December 13, 2017 at 1:43 pm
select definition from sys.sql_modules
where object_id = object_id('MyTestProc')
September 25, 2017 at 8:37 am
In a Server Name drop-down box, move your mousepointer down to the server you want to delete, don't click it, but press Delete button on your keyboard.
Repeat the same for...
August 9, 2017 at 7:38 am
I can see the tabs only when all connections were successful, and this was the case for the last several days. However today, again I see just a pop-up message...
July 18, 2017 at 12:05 pm
For insert and delete you will need to take snapshots of sys.sysindexes before and after insert or delete. Look for rowcnt or rows columns. Alternatively you can also check sys.indexes-sys.partitions-sys.allocation_units...
July 12, 2017 at 9:12 am
Great! Thanks a lot Scott, it worked.
June 27, 2017 at 2:35 pm
Should I select snapshots from sys.dm_io_virtual_file_stats() before and after and provide delta for all columns ? If this is something different, could you please provide a script?
About table creation...
April 21, 2017 at 11:36 am
That's very interesting, and I would say very strange.
If I break it into two parts 1-select into #temp and 2nd - insert into my destination from #temp, the 2nd part...
April 21, 2017 at 10:34 am
Thank you again, Bill, but even after I removed all 4 shortcuts from selected command, I can't type anything in "Press shortcut keys:" text-box.
April 11, 2017 at 4:15 pm
Thank you, Bill.
Finally I could add Show Results Pane to buttons bar. I used to always work with keyboard, with minimal touching a mouse, I think this way is more...
April 11, 2017 at 2:34 pm
Excellent! Very useful info. Thanks a lot.
February 23, 2017 at 7:47 am
It's available in SYS.indexes as the filter_definition column.
this is a query I use to quickly...
January 13, 2017 at 12:46 pm
Viewing 15 posts - 46 through 60 (of 454 total)