Viewing 15 posts - 26,641 through 26,655 (of 49,552 total)
Err, only if you specify numeric with a 0 scale.
SELECT cast('1.45' AS Numeric(5,2)) returns 1.45
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 7:32 am
Stefan Krzywicki (4/18/2011)
Jeff Moden (4/18/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 7:26 am
Cross posting Jeff? 🙂
Higher compression. Ability to split the archive into multiple files (great for huge archives going onto CD/DVD or for getting through email limits). Encryption and passwords. There's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 7:24 am
May I ask why not? It's certainly going to be far less problematic, probably faster too.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 7:20 am
Higher compression. Ability to split the archive into multiple files (great for huge archives going onto CD/DVD or for getting through email limits). Encryption and passwords. There's far more.
The RAR...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 7:19 am
New question: New thread, and post details.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 6:21 am
If the filtered index's value can be changed to match the query, that query is as efficient as its going to get.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 6:01 am
Ignoring that workstation tools belong on workstations, why do you think that having them there is going to be a problem?
Remember with a cluster you connect to the virtual name,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 5:58 am
Of course you will be. That's the point of a cluster (and 2005 behaves the same way). Connect to the cluster's virtual name and you can connect from anywhere on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 5:23 am
What are the queries?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 5:19 am
parthi-1705 (4/18/2011)
1.Why NonClustered index scan alone take place & not Clustered index
Because all the columns needed for the query are in the nonclustered index and SQL did not need...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 5:19 am
Store it as a numeric, or cast to numeric.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 5:09 am
Minaz Amin (4/18/2011)
First let me caution you for having data & log file on network drive. As said by Gail Shaw
It's not just a caution. SQL 2008 will not allow...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 4:46 am
Do you really, absolutely need every single column? That'll make it near-impossible to cover the query properly.
Just select the absolute minimum columns that you need.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 4:35 am
Post the queries that you are using. Without seeing exactly what the queries are, it's near impossible to suggest anything meaningful.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 18, 2011 at 4:22 am
Viewing 15 posts - 26,641 through 26,655 (of 49,552 total)