Viewing 15 posts - 28,246 through 28,260 (of 39,961 total)
The way this works, is a new table is created, the data copied, the old one dropped, and the new one renamed.
It doesn't matter which GUI you use, this is...
June 25, 2008 at 1:59 pm
How are you retrieving the data? If you select the data, SQL Server returns all of it, but the client application may only show part of it.
In SSMS there are...
June 25, 2008 at 1:54 pm
Turn off the machine?
I guess you could just convert the physical to a VM, save it off somewhere on tape? Maybe the same thing for the db?
June 25, 2008 at 10:20 am
That's very true. Many HR departments buy surveys and use those titles to set ranges.
Maybe that's what you should do? Look for a good paying title and lobby for it!
And...
June 25, 2008 at 10:20 am
Sometimes it's cheaper. Other times it means hiring a consultant or another job for one of us.
Look at those "mistakes" as opportunities, and it won't seem so bad.
June 25, 2008 at 10:18 am
Gail,
I'd be interested to know which one you pick. I looked at an O'Reilly one and went through it in 2000/2001, but then got distracted with some VB.NET. Would like...
June 25, 2008 at 10:17 am
Good catch, I'll enable that one and XLSX now.
June 25, 2008 at 10:13 am
I'll paraphrase my buddy, Andy, who reminded me of his core tenet a week ago.
Go with the defaults until you have a reason not to.
Normalizing should be a default.
June 25, 2008 at 9:47 am
Great comments and like many of you, I fell into this job. I was a network admin, a CNE in a Novell environment and we got a SQL Server. It...
June 25, 2008 at 9:46 am
Just got back from 3 days of "vacation" at Scout camp with my two little kids. After some bad food, lots of sun, and sleeping on the ground, I need...
June 25, 2008 at 9:32 am
I think this is a great idea, and it's similar to one I've used to email myself DBA reports every day.
xp_sendmail has worked fine for me for years. And very...
June 25, 2008 at 9:05 am
If you read the internals books or dig into BOL, there are pages inside SQL Server that create a map for all allocations. Just as pages have a map of...
June 22, 2008 at 9:45 am
Check out xp_smtp from Gert Drapers. This might do what you need.
June 22, 2008 at 9:36 am
I thought I had read in a blog about changing this with newer servers that have multiple cores. There was some ratio of worker threads to cores that you could...
June 22, 2008 at 9:34 am
Hey, that's me. Missing the obvious, pointing out the obscure. 😉
June 22, 2008 at 9:19 am
Viewing 15 posts - 28,246 through 28,260 (of 39,961 total)