Viewing 15 posts - 16 through 30 (of 105 total)
Hi thnaks it works. Can you explain a bit how its working.
November 13, 2013 at 12:56 am
thaks for you inputs. As i need to run the script on the differnt server, to which do not have acess , I can not use insert statement mentioned....
November 12, 2013 at 11:42 pm
I dont want to insert to view. I have table and want to insert data retrived from this view.
November 12, 2013 at 4:08 am
thanks i had forgoten about computed column
November 7, 2013 at 3:56 am
I know its not working but gave exmaple to explain what i want 🙂
November 7, 2013 at 3:38 am
got it. I saved the text as .sqlplan file and then opend it. It shows graphicl plan.
November 5, 2013 at 4:13 am
One more query I could export and work with the trace. I capturing "Showplan All' event. How do I convert the textdata of this to graphical plan?
November 5, 2013 at 4:10 am
Thanks for you reply. Could you be able to give me steps to capture following info using sp_trace_setevent
1. want to capture quueries being executed
2. Date and time on which it...
November 5, 2013 at 12:27 am
Correct me if i am wrong Profiler not available in express.
How to start the trace in 2012 express edition?
Tried to search on net but could not find. Can you provide...
November 4, 2013 at 11:43 pm
Hi
We can monitor this event using the extended events. Want to store output of this event in a table . How do i do this?
Regards
November 4, 2013 at 3:13 am
Hi
Thanks Jonysuise and Bhuvnesh
I was reading about index fragmentation, thats when came across fragment_count. And could no understand the defiantion on the msdn site. So if you can elaborate...
October 17, 2013 at 5:45 am
Viewing 15 posts - 16 through 30 (of 105 total)