SQL Server 2008 - Table Valued Parameters(www.adathedev.co.uk)

submitted by AdaTheDev(119) 1 year, 11 months ago

A performance walkthrough of passing a dynamic number of values to an stored procedure using the new table valued parameter support within SQL Server 2008, in comparison with XML and CSV parameter approaches. read more...

add a comment |category: Database |Views: 24

tags: SQL sqlserver2008 Database Performance another

MERGE statement in SQL Server 2008(amosait.blogspot.com)

submitted by mosessaur(5424) 2 years, 9 months ago

In SQL Server 2008, you can perform insert, update, or delete operations in a single statement using the MERGE statement. read more...

add a comment |category: Database |Views: 13

tags: sqlserver2008 Database another

Best Practices for Integrated Full Text Search (iFTS) in SQL 2008(blogs.msdn.com)

submitted by Jemm(9604) 3 years, 3 months ago

"This blog [post] is a result of lessons learned while working with the new Integrated Full Text Search in SQL Server 2008. It is not intended to be an in-depth tutorial on how to implement it. Instead, it will concentrate on best practices." read more...

add a comment |category: Database |Views: 25

tags: fulltextsearch sqlserver2008 ifts Database another

Best Practices for Integrated Full Text Search (iFTS) in SQL 2008(blogs.msdn.com)

submitted by Jemm(9604) 3 years, 3 months ago

"This blog [post] is a result of lessons learned while working with the new Integrated Full Text Search in SQL Server 2008. It is not intended to be an in-depth tutorial on how to implement it. Instead, it will concentrate on best practices." read more...

add a comment |category: Database |Views: 25

tags: sqlserver2008 fulltextsearch Database ifts another

Transaction and Local Variables - Swap Variables - Update All At Once (blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 3 months ago

Summary : Transaction have no effect over memory variables. When UPDATE statement is applied over any table (physical or memory) all the updates are applied at one time together when the statement is committed. read more...

1 comment |category: Database |Views: 14

tags: SQLAuthority SQL2K8 pinaldave Database SQLServer another

SQL 2008 FileStream – T-SQL,WPF, LINQ-TO-SQL(omarbesiso.spaces.live.com)

submitted by mosessaur(5424) 3 years, 3 months ago

SQL 2008 FileStream, T-SQL, LINQ to SQL & WPF putting all together read more...

add a comment |category: Database |Views: 118

tags: SQLServer sqlserver2008 LinqToSql Database WPF another

SQL Server 2008 - Cheat Sheet - One Page PDF Download(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 4 months ago

Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy. I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked. Let me know your opinion and if you find this useful. Bookmark it for future use. read more...

2 comments |category: Database |Views: 870

tags: SQLAuthority SQL2K8 pinaldave sqlserver2008 Database another

SQL SERVER - Guidelines and Coding Standards Complete List Download(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 4 months ago

Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where they should not prevent best practices for coding. They are basically the guidelines that one should follow for better understanding. The concept behind implementing coding standards and guidelines, is that the consistency and uniformity in programming so that if multiple people are working on the same code, it becomes easier to communicate, share with or understand each other’s work. With the goal of promoting good coding standards and guidelines I have created document which can guide developers. read more...

3 comments |category: Database |Views: 508

tags: sqlserver2k8 SQLAuthority pinaldave -1 SQL another

SQL SERVER - 2008 - Interview Questions and Answers - Download PDF(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 4 months ago

Interview is very important event for any person. A good interview leads to good career if candidate is willing to learn. I always enjoy interview questions and answers series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server is very large subject and not everything is usually asked in interview. In interview what matters the most is conceptual knowledge and learning attitude. I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to add to any of the question please send me mail or write a comment. Bookmark this first ever set of interview questions and answers. read more...

2 comments |category: Database |Views: 3633

tags: pinaldave SQL2008 SQLAuthority Database SQL2K8 another

SQL Server 2008 Management Studio tip: Status bar Custom Colors(blog.jemm.net)

submitted by Jemm(9604) 3 years, 6 months ago

"Here is a handy tip for those of you who work often with multiple SQL Server instances: Custom Colors for the connection status bar." read more...

2 comments |category: Database |Views: 286

tags: SQLServer sqlserver2008 Database Tips another

Sqlps.exe is the New Black(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 8 months ago

SQL Server 2008 sample code on importing OS perfmon or eventlog data with powershell. read more...

1 comment |category: Database |Views: 126

tags: sqlserver2008 SQL Database another

Ease your SSMS experience: SSMS Tools PACK 1.0 is out!(weblogs.sqlteam.com)

submitted by spirit1(3160) 3 years, 9 months ago

A popular free add-in for SQL Server Management Studio (SSMS) is now in release version 1.0. With many new and improved features it speeds up your SSMS development. read more...

add a comment |category: Database |Views: 259

tags: SQLServer2000 SSMS sqlserver2008 Database SqlServer2005 another

Table-Value Parameters in SQL Server 2008(dotnethitman.spaces.live.com)

submitted by misbaharefin(845) 3 years, 9 months ago

One of the cool new data types added in SQL Server 2008 is Table-Value Parameters. You can use table value parameters to send multiple rows of data to a Transact-SQL statement, or to a routine such as a stored procedure or function. This can be done without creating a temporary table or many parameters. Table-value parameters are like parameter arrays in Object Linking and Embedding Database (OLE DB) and Open Database Connectivity (ODBC), but offer better flexibility and closer integration with Transact-SQL. Table-value parameters can participate in set-based operations. read more...

add a comment |category: Other |Views: 26

tags: TableValueParameters sqlserver2008 another

Download Free E-Book: Introducing SQL Server 2008(mosesofegypt.net)

submitted by mosessaur(5424) 3 years, 10 months ago

learn about major new features in SQL Server 2008, including security, administration, and performance. Downloading the book require registration. read more...

add a comment |category: Database |Views: 368

tags: sqlserver2008 Books Database another

Microsoft SQL Server Reporting Services White Paper(weblogs.sqlteam.com)

submitted by kprernn(1445) 3 years, 10 months ago

Link to a Microsoft SQL Server 2008 Reporting Services White paper. read more...

add a comment |category: Database |Views: 95

tags: sqlserver2008 SSRS ReportingServices Database SQL another

Filtered indexes not compatible plan reuse??(statisticsio.com)

submitted by StatisticsIO(240) 3 years, 10 months ago

A tsql example of using filtered indexes in SQL Server 2008 and their plan reuse behavior. read more...

add a comment |category: Database |Views: 0

tags: sqlserver2008 Database another