|
|
-
13
Liked
| 12
Learned
| 11
Comments
|
|
Adding the /NOSPLASH option to your Visual Studio\BIDS shortcut will make Visual Studio\BIDS launch quicker :
%ProgramFiles%\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe /NOSPLASH
%ProgramFiles(x86)%\Microsoft Visual Studio 10.0\Common7\IDE\d......
|
|
-
44
Liked
| 42
Learned
| 11
Comments
|
|
The IN clause in T-SQL can be used to find a single value present in any one of multiple supplied columns. For example, in the AdventureWorks database:
[code]
SELECT Title, FirstName, MiddleName, LastName, Suffix
FROM Person.Contact
WHERE 'Lee' I......
|
|
-
|
|
Yesterday night, I was reading Inside Microsoft Sql server 2008: Programming - Itzik Ben-Gen. On Cursors section Page number 291, he has tried to explain the scenario for calculating multiplication on row wise manner. He has explained through cursor. Be...
|
|
-
10
Liked
| 10
Learned
| 10
Comments
|
|
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
|
-
|
|
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ser...
|
|
-
16
Liked
| 17
Learned
| 10
Comments
|
|
One of the problems I always faced when storing multi-line text into a SQL Server table is the trouble in retrieving it and analysing it in SSMS. If I take output to Grid, I will lose the line breaks and formatting. If I take output to text, it is trunc......
|
|
-
20
Liked
| 11
Learned
| 10
Comments
|
|
I have always heard about the terms sargable and non-sargable but never really understood how they help in developing efficient sql code. Here is what I have found out...
Try to avoid WHERE clauses that are non-sargable. The term “sargable” (which is i...
|
|
-
13
Liked
| 11
Learned
| 10
Comments
|
|
Microsoft has a free SEO toolkit, which can be used to identify the SEO problems in your website. You can install it from here.
http://www.microsoft.com/web/seo/
Once, you install the tool, you can open IIS and analyze any website. Once analysis ......
|
|
-
14
Liked
| 14
Learned
| 10
Comments
|
|
Just learned from focus.com's Editors article.In that they have identified Top 10 Largest Databases in the World, Here we have the list.
I)The Library of Congress (LC) boasts more than 130 million items ranging from cook books to colonial newspapers ......
|
|
-
22
Liked
| 15
Learned
| 10
Comments
|
|
Aggregate functions always return at least one row. So using aggregate functions to check for the existance of data will not give correct results. See the results returned from these queries
[code]
declare @t table(i int)
if exists(select i from @t......
|
|