Viewing 15 posts - 12,961 through 12,975 (of 22,214 total)
laddu4700 (3/22/2011)
how many ways can we create reports in SQL Server 2005, what is the easy and comfortable way to provide report to user
How many ways can you...
March 23, 2011 at 5:30 am
I don't have a 2005 SSMS to check this, but in 2008, you can right-click on Jobs and open the Manage Schedules window. It shows all the existing schedules for...
March 23, 2011 at 5:26 am
sppdba (3/22/2011)
March 22, 2011 at 3:41 pm
Stefan Krzywicki (3/22/2011)
Grant Fritchey (3/22/2011)
Brandie Tarvin (3/22/2011)
Oh, hey, completely non-SQL related link:If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).
Makes me...
March 22, 2011 at 1:46 pm
It depends on the DMV. Many of the most interesting ones about query performance are completely dependent on the cache. Others work off the last time SQL Server was restarted...
March 22, 2011 at 1:42 pm
Brandie Tarvin (3/22/2011)
Oh, hey, completely non-SQL related link:If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).
Makes me miss film making. I...
March 22, 2011 at 1:38 pm
GilaMonster (3/22/2011)
Brandie Tarvin (3/22/2011)
March 22, 2011 at 1:20 pm
Pei Zhu-415513 (3/22/2011)
Thanks. In other words, if it ran successfully, the production is clear off the corruption as of the time backup took place. But if it failed, you wouldn't...
March 22, 2011 at 11:28 am
chandan_jha18 (3/22/2011)
Grant Fritchey (3/22/2011)
You're getting a scan on one table, overall, the system...
March 22, 2011 at 6:21 am
It's hard to do more than suggest general approaches based on the information provided.
The one concern I would have with the existing structure: what do the cluster indexes look like?...
March 22, 2011 at 5:19 am
Looking at the code, this is a query against a view. What does the view code look like?
You're getting a scan on one table, overall, the system is processing 35000...
March 22, 2011 at 5:10 am
Just so you know, nesting views adds considerably to the work the optimizer has to do to unpack the views to try to get to an optimal execution plan. When...
March 22, 2011 at 4:59 am
Roy Ernest (3/21/2011)
Have anyone heard of Hampton Inn in Plymouth? If so what do you think?
She is crying when I told her that Duxbury is...
March 21, 2011 at 3:27 pm
Roy Ernest (3/21/2011)
Stefan Krzywicki (3/21/2011)
Roy Ernest (3/21/2011)
March 21, 2011 at 11:50 am
Viewing 15 posts - 12,961 through 12,975 (of 22,214 total)