IntelliSense in SQL Server 2008 not showing suggestions? Four ways to Enable IntelliSense, starting with connecting to a 2008 instance and checking Tools, Options.
How Many CPUs SQL Server Really Uses
CPUs SQL Server really uses depend on edition, guest topology, affinity, and online schedulers; learn to see the instance’s usable capacity.
SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users
In SQL Server 2008, Activity Monitor is empty for a user without the right permissions. Here is how to fix Activity Monitor for all users.
geometry STEquals: Equal Shapes Can Have Different Text
geometry STEquals compares the represented point set, which can stay the same when its text representation changes. I separate that question from byte-for-byte text identity. Reversing a line does not necessarily change the places it occupies.
SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones
Today is my 900th article on this blog. You can see list of all the 900 articles here. I suggest you go over the list and read any article you like.
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display
SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.
NULLIF Text: Collation Decides Whether Values Match
NULLIF text comparisons can remove a matching value. Select the matching rule explicitly and preserve the first expression’s return contract.