Viewing 15 posts - 21,061 through 21,075 (of 22,224 total)
I've used both. In terms of messaging, there's no real difference between them. Blackberries are a bit more sophisticated in terms of actually chatting to other human beings, but when...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2008 at 9:50 am
Jeff,
Doesn't the fact that floats are imprecise estimates represent a pretty major possible problem in using them in financial calculations? At least that's what I've always been told. I mean...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2008 at 9:45 am
If you can't purchase tools, here's another option.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2008 at 8:34 am
Definitely a backup and a restore is the much easier route. All the data, all the structure, all the statistics, just as they are in production. Done.
However, you can create...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2008 at 6:01 am
There's this company, called Microsoft. Searching their web site can find all sorts of stuff.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2008 at 5:45 am
I provided a link in the post above to MS's tool. Here it is exposed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2008 at 5:34 am
You really don't need to contact MS. The answer is 99. Matt Miller has not only documented it, he's tested it to confirm. 99 is as high as you can...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 12, 2008 at 6:42 pm
Check the logs. If you had six, you should have seven now. Cycling the error logs simply stops the logging in one log and starts it in the next, new...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 12, 2008 at 1:23 pm
Why on earth would you need more than 99 error logs? Actually, why would you need more than ten?
The thing I suggested would just show you if you had more...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 12, 2008 at 1:10 pm
Itzik Ben Gan from Solid Quality Mentors. He wrote the book, literally.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 12, 2008 at 12:49 pm
Cycle the error log:
EXEC sp_cycle_errorlog;
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 12, 2008 at 12:47 pm
It's not like date fields where there are a lot of special functions. We just use decimal.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 12, 2008 at 10:37 am
It depends (I love that answer). To me, this is a business definition. Strictly looking at data, as data, no, none of these columns help to define the Address object....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 12, 2008 at 5:30 am
Absolutely true.
You also might want to look at having simply an Address table with a join table to associate addresses to contacts. That way when you get a married couple...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2008 at 10:17 am
The first four of those columns you're talking about are there for auditing purposes and shouldn't have anything to do with relational integrity. The last column, the guid, I'm assuming...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2008 at 9:36 am
Viewing 15 posts - 21,061 through 21,075 (of 22,224 total)