Viewing 15 posts - 3,286 through 3,300 (of 6,679 total)
Basically, I will either use the GUI - or I will use powershell, depending upon how many databases and what else is going on at the moment.
April 12, 2011 at 7:50 pm
After creating a new database, I will change the owner of the database to sa. It doesn't matter who I am logged in as - whether that is a...
April 12, 2011 at 5:24 pm
TheHose (4/12/2011)
Microsoft SQL Server Management Studio10.0.2531.0
Microsoft Analysis Services Client Tools10.0.1600.22
Microsoft Data Access Components (MDAC)3.86.3959
Microsoft MSXML2.6 3.0 4.0 6.0
Microsoft Internet Explorer8.0.6001.18702
Microsoft .NET Framework2.0.50727.3615
Operating System5.2.3790
Oh it's still...
April 12, 2011 at 5:19 pm
Just to be clear - rebuilding indexes is causing the database to grow, then you shrink the database which is causing the indexes to become fragmented.
Then, you rebuild...
April 12, 2011 at 2:58 pm
rebuild does an update stats as well. reorg doesn't touch the stats
A little clarification...an index rebuild will update index statistics with a full scan. Column statistics are not updated....
April 12, 2011 at 2:52 pm
Okay, now we will need to see how you are using this view - and the execution plan. With that said, I see a couple of issues right away:
1)...
April 12, 2011 at 11:26 am
After reading Gail's article on catch all queries - you should also review Erland's article on dynamic SQL.
Whether or not you decide to go with dynamic SQL, a catch all...
April 12, 2011 at 11:14 am
Perry Whittle (4/12/2011)
no need to take a FULL backup here to restart the log chain, a DIFFERENTIAL will suffice and allow subsequent transaction log backups
This is true, but the log...
April 12, 2011 at 7:25 am
You should review the following article by Erland: http://www.sommarskog.se/dyn-search-2005.html
It goes through the various different options of writing dynamic queries for searching. Most likely, the best option for this would...
April 11, 2011 at 9:20 pm
You need to post the definition of the view, and probably the definition of the tables and indexes - with some sample data, and the query you are using that...
April 11, 2011 at 9:13 pm
If the SQL Server agent job is owned by a member of the sysadmin role, it will run in the context of the service itself.
On Windows Server 2008...
April 11, 2011 at 9:02 pm
GilaMonster (4/11/2011)
April 11, 2011 at 2:39 pm
You do not need to run both a rebuild and a reorganize task - unless you are selecting different indexes for each task.
The failure you are getting is caused when...
April 11, 2011 at 2:32 pm
I am not sure what you mean by stopped working - did you check the maintenance plan history, job history, agent logs and sql server logs?
Any errors or issues showing...
April 11, 2011 at 11:12 am
annasql (4/8/2011)
So if there is no tie in, then if we use that domain account which run sql agent service for other purpose for...
April 11, 2011 at 11:08 am
Viewing 15 posts - 3,286 through 3,300 (of 6,679 total)