Chinese collation that has Latin case-insensitive characters?
Aug 25, 2015 · In SQL Server, collations control the code page that is used to store the character data in non-Unicode data types like char and varchar. Code pages define bit patterns for uppercase and …
Using Case Statements in Named Calculations
Sep 23, 2011 · I'm a newbie SQL Server developer and I've recently started using SQL Server 2008 R2. I have a Date dimension table which has a Month column. This column however only stores integer …
case statement for count between two dates
Mar 14, 2013 · Basically I would like to calculate the number of orders in the case statement between two parameters rather than using the where clause as I would like to count other things in the select …
error in using case when then in sql - social.msdn.microsoft.com
Oct 7, 2021 · All replies 0 Sign in to vote User-661350001 posted there is no need of comma CASE WHEN ISNULL( [Stat_Days_Over],0)<31,THEN 30,ELSE(CASE WHEN[Stat_Days_Over]<61, THEN …
Collation problems on deploy - social.msdn.microsoft.com
Jul 29, 2010 · I have my project's collation set to "English (United Kingdom) (2057) - CI" because the system needs to be case insensitive. My local dev SQL Server's default collation is set to …
Performance ADO.NET vs EF - social.msdn.microsoft.com
Jan 9, 2012 · For example best case I can get a query to run and return results in 1 millisecond, worst case it might take SQL 1000 milliseconds if I send a poor query. The worst client API code probably …
Named Pipes Provider: Error 2 - social.msdn.microsoft.com
Jul 10, 2009 · Is this a remote connection or a local connection? I'm guessing this is a remote connection, since you're talking about the firewall, and in that case, do you have remote connections, …
Find partitions, row count of each partition of a partition table
Jan 13, 2017 · See Detailed list of all tables and their size, it queries the required Information from DMV Partition statistics.
Switch () in MDX - social.msdn.microsoft.com
Dec 12, 2008 · MDX is (trying to be) more like T-SQL, so the name of the command is CASE.
SSIS package take more time than usual
Jul 18, 2016 · In this case, are you using more than one SQL Agent job to execute the multiple packages? If you are using more than one SQL Agent job to execute the multiple packages, please …