Viewing 15 posts - 5,476 through 5,490 (of 5,678 total)
One item of note: If you manually set the tempdb size via properties, it rebuilds to that size even though it resets the database. You may still need...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 1:26 am
chrisjkelly (9/21/2010)
Thanks for the advice and for keeping it simple.
Is it safe to carry out a shrink on the tempdb? and would simply stopping our application service on the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 1:14 am
I'd personally use a proc with a bunch of IF/ELSE IF, if I had to do this. Pretty? No. Easy to maintain? No. Best way I've...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 1:05 am
Well, once the db grows to a size it doesn't autoshrink, usually. If you're running DBCC regularly you'll want to leave the space there so it doesn't have to...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 1:03 am
Since you admit you're not a DBA I'll do my best to keep this easy. 🙂
You can shrink the tempdb via the interface. Open the server up, open databases...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 1:00 am
Well, if I'd ever seen a request for a tally table solution, this would be it. 🙂 Much easier to build out the necessary pre-array this way.
Check out this...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 12:49 am
Here's a link to an article that describes what you're looking for:
It was the second link when I typed in at google: ms sql change object schema.
😀
The command you're looking...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 12:23 am
Okay, what the check is trying to do is be able to scan the table, end to end, and make sure it's correct, allocated, etc etc.
To do this, without screwing...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 12:17 am
Getting this error off qry1:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Error loading execution plan XML file C:\ssc\qry1.sqlplan. (Microsoft.SqlServer.Express.SQLEditors)
------------------------------
ADDITIONAL INFORMATION:
There is an error in XML document (1009, 15). (System.Xml)
------------------------------
Data at the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 12:12 am
You can post it here, or if it's very large, there's an 'edit attachments' button at the bottom of all posts. You can copy/paste your script to MSWord, notepad,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 12:01 am
Ah! So, to clarify, you're looking for a script or some other way to change all your objects from dbo.object to rescon.object?
Such as dbo.TableA to Rescon.TableA?
And you want to do...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 21, 2010 at 12:00 am
I'm afraid to help you puzzle out your solution, I'm going to need more from you. DDL's of all the base tables, sample data, and expected results from the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2010 at 11:49 pm
elayevskiy (9/20/2010)
My test environment has SQL 2005 developer's edition, but my production one has Workgroup edition. So I have to use (NOEXPAND) for production environment.
Ahhh. That's needed to...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2010 at 11:31 pm
Bhuvnesh (9/20/2010)
.2. it contains 18000 tables,there are couple of heavy table like 18 -19 GB.
There's your 15 gig bump, needed snapshot room.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2010 at 11:19 pm
Cross posted, please direct all replies and discussion here: http://www.sqlservercentral.com/Forums/Topic989922-360-1.aspx
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 20, 2010 at 11:03 pm
Viewing 15 posts - 5,476 through 5,490 (of 5,678 total)