Viewing 15 posts - 721 through 735 (of 1,079 total)
vijay82 (7/16/2010)
How to troubleshoot a slow query?.what are the steps i have to follow?
post the query so we can try to assist.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 16, 2010 at 1:52 am
Instead of explaining only whats needed for backups, read this, would explain all roles much better..
http://articles.techrepublic.com.com/5100-10878_11-1061781.html
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 16, 2010 at 1:44 am
run:
sp_helpdb to see the actual sizes of your attached databases.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 16, 2010 at 1:35 am
Yes, I've tested and no issues.
The designer is 2010, but the web part will work on SP 2007 as well.
Good Luck.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 16, 2010 at 12:14 am
This is the same QOTD from 9 July 2010 😀
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 15, 2010 at 10:27 pm
Yes you can, and it works great!
Download Sharepoint Designer 2010 - it's free, and unleash the power 😀
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 15, 2010 at 6:16 am
a backlog will start on your host, and as soon as the destination is available you need to ensure it starts again, the log shipping job under the agent will...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 13, 2010 at 3:32 am
Grant Fritchey (7/2/2010)
Steve Jones - Editor (7/1/2010)
What did I do?I'm not renewed now. And perhaps I won't be if PASS gets to weigh in.
Did that blog post upset people? It...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 2, 2010 at 5:34 am
Sree-258588 (7/2/2010)
Hion selecting next button I need to show the next 10 records. how to do this.
what "next" button?
Are you querying from a custom application?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 2, 2010 at 4:58 am
Not exactly sure what you are after, but try these..
sys.dm_repl_articles
sys.dm_repl_schemas
sys.dm_repl_traninfo
sys.dm_repl_tranhash
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 2, 2010 at 4:44 am
Create a sql agent job, with tsql commands as steps, and configure them there.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 2, 2010 at 4:39 am
singhsatnam84 (7/2/2010)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 2, 2010 at 4:38 am
sachinsoni84 (7/2/2010)
if a stored procedure has 50 Tsql statment and it is suddenly showing slow performance, how wud i trouble shoot n tune it??
look at the table's it uses....stored procedure...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 2, 2010 at 2:38 am
simple script, but should give you the results...
select name,
database_id,
user_access_desc,
state_desc,
(CASE is_in_standby WHEN '0' THEN 'NO' ELSE 'YES' END) as Is_in_standby,
GETDATE() as time_stamp
from sys.databases
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 1, 2010 at 4:56 am
SQLSeTTeR (7/1/2010)
SQL Server must shut down in...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 1, 2010 at 4:28 am
Viewing 15 posts - 721 through 735 (of 1,079 total)