A SQL Server Leap Year Test Function(www.blackwasp.co.uk)

submitted by BlackWasp(4024) 13 days, 18 hours ago

Transact-SQL does not provide a standard function that allows developers to determine if a year is a leap year. This article describes two functions. One to calculate the number of days in a year and one that utilises the result to identify leap years. read more...

add a comment |category: SQL |Views: 3

tags: SQL another

SQL Server Virtualization Notes(cecildt.blogspot.com)

submitted by cecildt(203) 18 days, 8 hours ago

Virtualization of SQL Server these days are becoming more a reality and common practice. Usually if you mention SQL Server and Virtualization in one sentence people will look at you as if you are a mad man. With this post I would like to talk about a couple of notes you need to consider when you virtualize SQL Server. When using a hypervisor to consolidate your SQL Servers into a virtualization environment you need to think about the impact on CPU, Memory, Storage and Network performance and management. read more...

1 comment |category: SQL |Views: 100

tags: SQL another

Run Your Custom Script Quickly with SSMS Tools Pack(techbrij.com)

submitted by urenjoy(267) 23 days, 23 hours ago

You can run your script in object explorer of sql server management studio using SSMS tools pack read more...

add a comment |category: SQL |Views: 3

tags: SQL another

NoSQL No More: Let’s double down with MoreSQL(tatiyants.com)

submitted by atatiyan(112) 30 days, 21 hours ago

For far too long now I have sat idly by as the NoSQL movement spread across our industry. One after another, these so-called “databases” with weird names have been attacking the sanctity of my beloved relational databases. The time has come to stand up to the scourge of NoSQL. Today, I am calling on developers everywhere to join a new movement dedicated to bringing back the golden era of relational databases: MoreSQL. read more...

add a comment |category: SQL |Views: 19

tags: geekHumor NoSql SQL another

Create Linked Server to connect to a SQL Server Part – II(learnsqlwithbru.com)

submitted by BruMedishetty(10) 1 month ago

In this blog we shall learn two more ways of creating a Linked Server for a SQL Server destination. read more...

1 comment |category: SQL |Views: 4

tags: LinkedServer SQL another

How to enable File stream in SQL Server 2008(www.dotnetplace.com)

submitted by composeme(914) 1 month, 26 days ago

In this article you will learn how to enable file streaming in SQL Server 2008 read more...

add a comment |category: SQL |Views: 1

tags: SQL another

Defragging SQL Indexes(www.danielahill.com)

submitted by resabio(80) 1 month, 29 days ago

Similar to hard drives, each time data in a SQL index is added, deleted, or updated, the index has the potential to become fragmented. The ultimate result is that SQL queries will take a less than optimal time to execute. Just as defragging a hard drive can improve performance, defragging SQL Server indexes can improve performance significantly. read more...

add a comment |category: SQL |Views: 5

tags: SQL another

SQL Dirty Pages (www.sqlservercentral.com)

submitted by rcash(4144) 2 months, 11 days ago

This article briefly describes how SQL Server manages data, how dirty pages are created, and what process is taken to write them to the disk. read more...

add a comment |category: SQL |Views: 2

tags: SQL another

SQL Server 2012 RC0 is here!(blogs.lessthandot.com)

submitted by rcash(4144) 2 months, 22 days ago

This is a short article about the new features available in MS SQL 2012. You can find the download at, “SQL Server 2012 Release Candidate 0 (RC0)”. http://www.microsoft.com/download/en/details.aspx?id=28145 read more...

1 comment |category: SQL |Views: 41

tags: SQL another

Understanding SQL Server 2008 R2 Execution Plan(www.machinaaurum.com.br)

submitted by xunilrj(70) 2 months, 30 days ago

In this post we are going to understand the SQL Server 2008 R2 Execution Plan and the differences between Clustered and Non-Clustered Index Seek and Scan, Included Columns and others index-things in SQL Server. read more...

add a comment |category: SQL |Views: 3

tags: SQL another

MS Sql Query Optomization Tips(csharpdotnetfreak.blogspot.com)

submitted by amit.jain(904) 3 months, 26 days ago

Sql Query Optimization in MS SQL Server To Improve Performance of ASP.NET web applications. read more...

add a comment |category: SQL |Views: 4

tags: SQL another

How to find the SQL Server Version with a query ?(www.ginktage.com)

submitted by isenthil(2199) 3 months, 28 days ago

How to find the SQL Server Version with a query ? Few days back , i had to find the SQL Server Version on one of the Machine and here’s a query that i used or executed in the SQL Server Management Studio to find out the version of the SQL Server .Select @@version The @@version will return “Microsoft SQL Server 2008 R2 (RTM) – 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 read more...

add a comment |category: SQL |Views: 1

tags: SQL another

A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID (sqltrends.blogspot.com)

submitted by sagitariusmzi(115) 4 months, 16 days ago

when you try to add filestream column to store images in database, you might this problem A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column read more...

add a comment |category: SQL |Views: 2

tags: SQL another

SQL server 2008 - Declaring varibles and initializing values in single(www.aspxtutorial.com)

submitted by composeme(914) 4 months, 16 days ago

The following script demonstrates how to declare variables and initialized values in one statement in SQL Server 2008. read more...

add a comment |category: SQL |Views: 2

tags: SQL another

MSSQL - Checking Uptime(www.stev.org)

submitted by mistralol(283) 4 months, 18 days ago

Sending an sql server alert if it restarts. read more...

add a comment |category: SQL |Views: 1

tags: SQL another

Database Worst Practices – New Town and New Job and New Disasters(blog.sqlauthority.com)

submitted by pinaldave(9662) 7 months ago

Instead of writing best practices, I am going to write about few of the worst practices which I have quite often seen in the real world. Some of them are really bad that I often wonder how those who still use them were able to continue on the job so far. Let us go over few of the worst practices I have observed in the industry. read more...

1 comment |category: Database |Views: 204

tags: SQLAuthority pinaldave SQLServer Database SQL another