SQL Data Decimation by Date Range and Nth Record(www.arroyocode.com)

submitted by Arroyocode(101) 4 days, 13 hours ago

Data decimation (aka Down Sampling) of large SQL datasets allows application to quickly visualize trends in data over large historical periods greatly improving application performance. Combining a custom date range and a SQL Modulo operator, quickly and evenly display long periods of data. read more...

3 comments |category: SQL |Views: 63

tags: SQL another

Code !t: Choosing the cloud for your database(www.etabakov.com)

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

You will find some tips and advices on how to choose your cloud provider for storing the database read more...

add a comment |category: Database |Views: 12

tags: cloud Azure rds Database SQL another

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

submitted by isenthil(2314) 15 days, 8 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) 25 days, 1 hour 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) 25 days, 14 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) 26 days, 1 hour 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) 26 days, 23 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(342) 1 month, 2 days 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, 2 days 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, 3 days 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

String Matching in LINQ(blogs.telerik.com)

submitted by jnpetrov(95) 1 month, 4 days ago

Performing simple string equality tests is often not enough when application user convenience is key. Often only a fragment of a string is known to the user, or many of them. Sometimes there is a need to search for a fragment in multiple columns. Which options does OpenAccess and LINQ provide to perform string matching? Into which SQL is the LINQ expression translated? read more...

add a comment |category: Linq |Views: 320

tags: ORM SQL LINQ another

Column Store Indexes in SQL Server 2012 - An Insight.(irohitable.com)

submitted by rpk2006(81) 1 month, 12 days ago

Learn how Column Store Indexes work and boost performance. read more...

2 comments |category: SQL |Views: 116

tags: SQL another

Understanding Sequences in SQL Server 2012 (Denali) - Part 1(www.irohitable.com)

submitted by rpk2006(81) 1 month, 19 days ago

What are Sequences in SQL Server 2012? read more...

add a comment |category: SQL |Views: 9

tags: SQL another

Sql Server 2008 Replication(emrecirik.com)

submitted by emrcrk(28) 1 month, 26 days ago

SQL Server 2008 Replication example read more...

add a comment |category: SQL |Views: 10

tags: SQL another

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

submitted by amit.jain(1186) 2 months, 1 day 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, 21 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