Stories recently tagged with 'SQL'

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

submitted by BlackWaspBlackWasp(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: |Views: 3

tags: another

SQL Server Virtualization Notes(cecildt.blogspot.com)

submitted by cecildtcecildt(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: |Views: 100

tags: another

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

submitted by urenjoyurenjoy(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: |Views: 3

tags: another

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

submitted by atatiyanatatiyan(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: |Views: 19

tags: another

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

submitted by BruMedishettyBruMedishetty(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: |Views: 4

tags: another

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

submitted by composemecomposeme(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: |Views: 1

tags: another

Defragging SQL Indexes(www.danielahill.com)

submitted by resabioresabio(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: |Views: 5

tags: another

SQL Dirty Pages (www.sqlservercentral.com)

submitted by rcashrcash(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: |Views: 2

tags: another

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

submitted by rcashrcash(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: |Views: 41

tags: another

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

submitted by xunilrjxunilrj(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: |Views: 3

tags: another

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

submitted by amit.jainamit.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: |Views: 4

tags: another

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

submitted by isenthilisenthil(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: |Views: 1

tags: another

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

submitted by sagitariusmzisagitariusmzi(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: |Views: 2

tags: another

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

submitted by composemecomposeme(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: |Views: 2

tags: another

MSSQL - Checking Uptime(www.stev.org)

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

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

add a comment |category: |Views: 1

tags: another

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

submitted by pinaldavepinaldave(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: |Views: 204

tags: another