Fix for IntelliSense feature in SSMS 2008 R2 may stop working ...(www.ginktage.com)

submitted by isenthil(2309) 13 days, 11 hours ago

Today , i encountered a wiered thing in my SQL Server Management Studio 2008 R2 where the intellisense was somehow not working in SSMS 2008 R2 read more...

add a comment |category: SQL |Views: 9

tags: SQL another

On the road less traveled: a DBA Roadmap review(marlonribunal.com)

submitted by Marlonr(704) 23 days, 4 hours ago

If you are a SQL Server DBA with 2-3 years worth of experience or even a mid-level SQL pro looking to advance his career and thinking that he could use an advice or two, you owe it to yourself to purchase this seminar. read more...

add a comment |category: SQL |Views: 5

tags: SQL another

Lengh of LOB data to be replicated exceeds configured maximum 65536 (sqltrends.blogspot.com)

submitted by sagitariusmzi(123) 23 days, 18 hours ago

Whenever we try to replicate data from a database that saves the images(filestream) in the database, and you have included those images in your replication, then you might get this error Length of LOB data (583669) to be replicated exceeds configured maximum 65536 Solution: There are two solutions for this problem using TSQL sp_configure 'max text repl size', '2147483647' GO RECONFIGURE using SQL Server Manager Studio In Object Explorer, Right click on your server name and select properties Click the Advanced node Under Miscellaneous option, change Max Text Replication Size to the desired value. read more...

add a comment |category: SQL |Views: 4

tags: SQL another

Who Are The Sysadmins In This SQL Server? (marlonribunal.com)

submitted by Marlonr(704) 24 days, 5 hours ago

When you're working on a sql server database, it is critical who has complete of your server. read more...

add a comment |category: SQL |Views: 6

tags: SQL another

Code !t: The most unappreciated feature in Sql Server 2008?(www.etabakov.com)

submitted by etabakov(10) 25 days, 3 hours ago

There is a feature in Sql Server 2008, that from my point of view has been hugely neglected. This is the Change Data Capture feature. Its main purpose is to keep historical data for all changes that happen in a given database. Check this post and learn more ... read more...

add a comment |category: SQL |Views: 13

tags: SQL another

SQL Query To Check Money Data Type and Convert to Decimal Dynamically(techbrij.com)

submitted by urenjoy(337) 1 month ago

How to convert one data type to another in sql server query dynamically. read more...

add a comment |category: SQL |Views: 2

tags: SQL another

Simple method to constrain stored procedures by a collection(www.charlesrcook.com)

submitted by ccook(320) 1 month, 1 day ago

Passing a collection of ID's to filter a SQL query within a stored procedure is not natively supported. Consider this article which discusses methods for passing arrays into a stored procedure. Constraining a stored procedure's query has a simple work around, however. Passing the ID collection as a comma deliminated string allows the query to use LIKE to constrain the results. Note that the preceding and trailing commas are necessary. An example demonstrates how to do this easily. read more...

add a comment |category: SQL |Views: 8

tags: SQL another

Iterating through all the SQL Server databases and tables.(irohitable.com)

submitted by rpk2006(81) 1 month, 1 day ago

SQL Server (2005 and above) contains two undocumented stored procedures, viz. sp_MSforeachdb and sp_MSforeacheable which can be used to loop through all the databases and tables and execute a command. read more...

add a comment |category: SQL |Views: 7

tags: SQL another

Reset Identity Column Value In Sql Server(www.csharpaspnetarticles.com)

submitted by amit.jain(1181) 1 month, 29 days ago

f we delete All data from Sql Server table having Identity Column with Identity Seed as 1 and insert new data Identity column value doesn't get reset and it starts from last number. read more...

add a comment |category: SQL |Views: 8

tags: SQL another

T-SQL features in SQL Server 2012 (www.techbubbles.com)

submitted by kalyanms1(1789) 2 months, 20 days ago

This post discuss about new T-SQL features in SQL Server 2012. The features which I am going to discuss here are Window Functions. Windowing and additional analytic functions are very cool and they are replacing cursors in T-SQL. Cursors are still available for use but windowing functions give better performance over cursors. read more...

add a comment |category: SQL |Views: 14

tags: SQL another

Entity Framework (Code First): the easy way to run stored procedures(code-clarity.blogspot.com)

submitted by hkurabko(85) 3 months, 5 days ago

This article describes how to run SPs without manually specifying such a boring stuff as parameters of SP. Extension methods can do this itself. read more...

add a comment |category: SQL |Views: 12

tags: SQL another

SQL writers, bloggers are not citing their sources(www.texastoo.com)

submitted by ab5sr(285) 3 months, 9 days ago

References? We don't need no stinking references! Or do we? read more...

add a comment |category: SQL |Views: 6

tags: SQL another

Making unit tests in SQL Server a first class citizen with Red Gate’s (www.troyhunt.com)

submitted by troyhunt(831) 3 months, 13 days ago

One area of unit testing that’s always been a little tricky is testing anything with a database dependency. In part, this is because those tests often end up being dependent on the data itself which, of course, can be highly volatile. But it’s also philosophically challenged in that if a unit test is to assess a discrete unit of code on the application tier then it probably shouldn’t have dependencies on the data tier. This is where Red Gate’s SQL Test comes in. It’s entirely self-contained within SSMS and all it does is tests business logic in the database, just like those first class cousins in Visual Studio. read more...

add a comment |category: SQL |Views: 3

tags: SQL another

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

submitted by BlackWasp(4212) 3 months, 27 days 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

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

submitted by urenjoy(337) 4 months, 7 days 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

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

submitted by BruMedishetty(10) 4 months, 14 days 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