Viewing 15 posts - 61 through 75 (of 115 total)
Yes, I did - and you knew exactly what you were looking at, but the other guy said it "looked like" something, so I gave him a resource that would...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 18, 2012 at 7:31 am
First of all, what OS are you running and is this a 32 bit or 64 bit server?
This really has a lot to say for how memory is handled....
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 18, 2012 at 7:21 am
Yes, my apologies for not being more precise. When there are more than 8 CPU cores, I generally don't create a TempDB file for each one above the initial 8....
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 18, 2012 at 4:50 am
The "GO" is not needed in this context, it's basically used to separate different batches of code. It's an old thing we inherited from the days of Sybase T-SQL on...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 18, 2012 at 1:24 am
For best results, if you're running a busy production server, you should place TempDB on a seperate drive and split it up into one file for each CPU. That way,...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 7:31 pm
Here's a great overview of versions and builds: http://www.sqlsecurity.com/faqs-1/sql-server-versions
The version number in the file properties (and in server properties inside Management Studio) lets you know exactly what build you're...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 7:13 pm
Peter2012 (10/17/2012)
Hi All,Thanks for your responses.
Please see my comments below.
select * from msdb.dbo.backupset where database_name='MOR'
-> Returns: 76 rows
Good, you've found your backups then. Hopefully you should find the ones you...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 7:02 pm
Actually, there should be a log from the previous run, but I'm unsure where that would be on your system.
Anyone else have some input here?
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 8:52 am
dbasql79 (10/17/2012)
[Hagen, Can you please explain a bit more of what could be the problem.
It's not necessarily a problem, just something you'll need to be aware of.
Each new version...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 5:55 am
ambesh.bharadwaj (10/16/2012)
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 5:50 am
Interesting! This also shows just the one instance. Does SQL Server Configuration Manager also show just one?
As Gail says, your installed programs overview shows 2 installations - one 2005 and...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 17, 2012 at 4:03 am
I'm not sure what caused your data file to grow and why you were unable to shrink it more than 2 gb, I wouldn't worry about it unless I really...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 16, 2012 at 6:39 pm
For the record, I might add that a truncate log does not actually clear individual records or transactions from the log. It simply clears all VLFs (Virtual Log Files) that...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 16, 2012 at 9:28 am
First of all, a transaction has to be committed in order for any updates it has made to become "official" in the database. In other words, you don't actually change...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 16, 2012 at 7:11 am
Hello.
Yes, you will need to restore transaction log backups (or a diff) if you are restoring to a point in time which is more recent than your latest full backup....
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
October 16, 2012 at 1:31 am
Viewing 15 posts - 61 through 75 (of 115 total)