RSS

Monthly Archives: July 2013

Difference between Count() and Count_Big() Funiction

In our Query Life when we need to get the Count of any Record in our Database Mostly we Use the COUNT() Aggregate Function the

Question Now SQL Server Have another  Aggregate Function COUNT_BIG() i asked my Self SQL Server Team Created this Function Whiteout any bin fits ……….. The answer is No . COUNT() and COUNT_BIG() it’s the Same Aggregate Function in the Use The Main Different between the two Aggregate Function it :

Count  Aggregate Function Return Int data type value .

COUNT_BIG()  Aggregate Function Return BigInt data type value .

So if you Have Millions Record in your table and you need to Return the Count of this Record when you use the Count() Function it will Return Error but the Count_Big() Function it will Work with you Simply in this Case .

Count() Aggregate Function :

Select Count(Column_Name) from Table_Name

Count_Big Aggregate Function :

Select Count_Big (Column_Name) From Table Name
 
Leave a comment

Posted by on July 20, 2013 in General topics

 

Install SQL 2014 must uninstall any SQL product

Today i tried to Install Ne SQL Server Version 2014 CPT to See what is new but before i started the Installation i usual Run the System Configuration Checker to See if my Environment is compatible
with SQL Server version or no
i see this failed

” Previous SQL Server product instillation ”
SQL Server other than SQL Server 2014 CPT 1 is detected
you can not install this version until the exacting instance of SQL product are uninstalled
i think this is bad

Untitled

 
Leave a comment

Posted by on July 6, 2013 in SQL Server 2014

 

biggest SQL Server-Performance Tuning Community

Dear All my Friends Thanks For lord Now i am Board Member of the biggest SQL Server-Performance Tuning Community Now for the 1st time in Gulf area and the middle east , we are announcing about the biggest SQL Server Communityhttp://sqlserver-performance-tuning.net/ ,it is fully of many rich blogs ,videos tutorials , offline and online events for widely concerned topics on Microsoft SQL Server like T-SQL performance optimization , Data Warehousing solutions, Replication Solutions , DMV scripts library ,new SQL Server 2012 features ,index tuning , heavy locks and deadlocks ..etc , we have a great passion to spread the word worldwide in generic and Gulf & Middle east in particular more, you can log in now easily to using your Facebook account , don’t forget to log in and register today
Also Follow us on
Facebook Page
Facebook Group
Linked in Group
Network Group
1005955_10151523279766247_1508277729_n
template-landscape-SM
 
Leave a comment

Posted by on July 3, 2013 in General topics