Viewing 15 posts - 136 through 150 (of 472 total)
I don't expect bleeding edge up to date, but at least teach current stuff. At a bare minimum this should be centered around SQL 2005 (IMO). I would...
The Redneck DBA
April 12, 2010 at 2:43 pm
Lynn Pettis (4/12/2010)
CirquedeSQLeil (4/12/2010)
GSquared (4/12/2010)
Just had a guy today who posted a whole exam, which he says "a friend needs for his masters program".
Where is that one? I...
The Redneck DBA
April 12, 2010 at 2:23 pm
In that case, what degree or cert is this "someone" working on? 😛
Good point. I don't mean to suggest it's not OK to ask for help. Just...
The Redneck DBA
April 12, 2010 at 11:09 am
Jeff Moden (4/12/2010)
The Redneck DBA
April 12, 2010 at 11:07 am
AMITLSBU (4/12/2010)
he is doing masters
Interesting. Just out of curiosity, what is the masters program in? Seems like some pretty basic SQL questions for a masters-level class.
The Redneck DBA
April 12, 2010 at 9:52 am
AMITLSBU (4/12/2010)
Thanks for your response.I am just trying to resolve this question for someone.
If you know the answers then please do reply.
Thanks in advance!!!
In that case, what degree or cert...
The Redneck DBA
April 12, 2010 at 8:39 am
I wonder if you can write a quick and dirty VB or C# front-end or CLR type of thing to accomplish this.
The Redneck DBA
April 7, 2010 at 11:44 am
george sibbald (4/7/2010)
Jason Shadonix (4/7/2010)
Personally, apart from system database backups. either they are all compressed or none are!
Why do you say that? Is there a reason you wouldn't want...
The Redneck DBA
April 7, 2010 at 11:32 am
as long as the option specified in sp_configure can be uniquely identified by the entry, you don't have to input the full name.
Neat! I didn't know that!
The Redneck DBA
April 7, 2010 at 10:06 am
--to enable compression
sp_configure 'backup comp', 1
go
reconfigure
go
Just curious but I don't recall reading anything within the TechNet article that mentioned a hierarchy requirement when doing WITH command. Why compression must come...
The Redneck DBA
April 7, 2010 at 9:35 am
Personally, apart from system database backups. either they are all compressed or none are!
Why do you say that? Is there a reason you wouldn't want to compress a backup...
The Redneck DBA
April 7, 2010 at 9:31 am
Steve Jones - Editor (4/7/2010)
this worked on my SS2K8 Dev editionBACKUP DATABASE db1 TO DISK = 'C:\db1.bak' WITH copy_only, COMPRESSION
I don't have COMPRESSION first in my list of options either...
The Redneck DBA
April 7, 2010 at 9:09 am
Are you talking SQL authentication or Windows authentication here?
The Redneck DBA
April 6, 2010 at 2:58 pm
ramuboddepalli (4/6/2010)
The Redneck DBA
April 6, 2010 at 2:49 pm
Lynn Pettis (4/2/2010)
You may want to use compression on your t-logs as well. I am doing it on all three to great success.
Yea, I thought about that. But...
The Redneck DBA
April 2, 2010 at 9:46 am
Viewing 15 posts - 136 through 150 (of 472 total)