Creating a New Report in Microsoft SQL Server
This brief tutorial will show you how you can reduce the amount of time you spend creating reports to run your business, with Microsofts SQL ...
Microsoft SQL Server 2005 EMC Datawarehousing Best Practices
Tune in as EMC's Chad Sakac, senior practice manager for databases and messaging, discusses the challenges of deploying a large database ...
Installing Microsoft SQL Server 2005 Express Edition
This video walks you through installing and configuring Microsoft SQL Server 2005 Express Edition which is a required element to use ...
Google Hacks 3.0
shows you security issues with Google that can allow you to hack other people's sites. Use this video to make sure your site is secure. CAMERA ...
IS4538 Infrastructures Behind Facebook - Open Source Benefits
for analysis. Running Hive above your Hadoop cluster will allow you to query the data using a SQL-like syntax; Hive will also manage the ...
Digg Headlines
SQL
(1 diggs) t-sql advice
I am new to sql server programming, and would like some advice on how to loop through a table and run a function for each row. As a VB programmer I would use a recordset or datareader to loop from beginning to end withwhile datareader.readloop[/Code]Is there something similar in t-sql?Thanks...Read more on t-sql advice
I am new to sql server programming, and would like some advice on how to loop through a table and run a function for each row. As a VB programmer I would use a recordset or datareader to loop from beginning to end withwhile datareader.readloop[/Code]Is there something similar in t-sql?Thanks...Read more on t-sql advice
(1 diggs) SQL Server 2008 T-SQL Enhancements
SQL Server 2008 introduces some T-SQL enhancements which is used to improve the database performance and maintenance.
SQL Server 2008 introduces some T-SQL enhancements which is used to improve the database performance and maintenance.
(1 diggs) SQL SERVER (T-SQL)- PATINDEX
In Sql Server PatIndex is really useful method works like SPLIT funcation in .net, It returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types..........http://blog.joggee.com/?p=156
In Sql Server PatIndex is really useful method works like SPLIT funcation in .net, It returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types..........http://blog.joggee.com/?p=156
(1 diggs) T-SQL to Grant permission in SQL Server
SQL to Grant EXECUTE permission to all Procedures and Functions
SQL to Grant EXECUTE permission to all Procedures and Functions