Viewing 15 posts - 19,351 through 19,365 (of 22,219 total)
It's not that computers don't store what you tell them to. In this case it's storing exactly what you told it to. A float is an approximate number. It's not...
"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
October 29, 2008 at 12:55 pm
I was just looking at this stuff:
Target Server Memory (KB) and Total Server Memory (KB)
Target Server Memory indicates the total amount of dynamic memory SQL Server is willing to consume....
"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
October 29, 2008 at 11:53 am
Yeah, post the actual execution plans, I think that's where you'll see the problem displayed clearly.
"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
October 29, 2008 at 7:24 am
Steve Jones - Editor (10/29/2008)
I thought this was a little silly...
"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
October 29, 2008 at 7:15 am
That's an awful lot of work for something you can get for free if you do one of two things. You can save your delimited string to a file and...
"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
October 29, 2008 at 5:55 am
You can set up the logins one of two ways. You can create a SQL login (not recommended) which has a name and a password. Better is to set up...
"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
October 29, 2008 at 5:51 am
Something else is going on. All things being equal, a static set of data and a static set of code is going to return the same values. As others have...
"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
October 29, 2008 at 5:44 am
Brackets are the way to go. If you used brackets within custom coding work in or around TSQL for anything other than naming database objects, you might be in trouble.
"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
October 29, 2008 at 5:42 am
Does this mean I get to carry a gun at work now?
I promise, no more than one developer a week. 😀
"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
October 29, 2008 at 5:32 am
Yeah, that's a pretty standard many-to-many relationship.
"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
October 28, 2008 at 11:35 am
Take a look at sys.dm_db_index_physical_stats. That will give you quite a lot of information about the index, including the number of pages, density, space used, etc.
You can just look at...
"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
October 28, 2008 at 8:29 am
ggraber (10/28/2008)
We are moving towards test-driven development and we are looking for a way to run...
"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
October 28, 2008 at 8:23 am
Shaun McGuile (10/28/2008)
Thanks Grant.I was specifically talking about;
Database synch
Database Compare
Data Generator
Comparisons.
SQL Compare has quite a bit more functionality than the Schema Compare tool in VSTSDBE. But, the new version coming...
"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
October 28, 2008 at 8:16 am
What if you changed those to OUTER JOINS within the main part of the FROM clause and then had something in the WHERE clause to only limit the data 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
October 28, 2008 at 8:02 am
Unless you're using a third party tool like HyperBac, you'll need to restore the entire database to a different location, either a second database on the server or a seperate...
"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
October 28, 2008 at 6:30 am
Viewing 15 posts - 19,351 through 19,365 (of 22,219 total)