JQUERYCOOKBOOK.COM

sqlservercurry.com

Copy a table from one database to another in SQL Server 2005

http://www.sqlservercurry.com/2008/03/copy-table-from-one-database-to-another.html

Copy a table from one database to another in SQL Server 2005. If you have a table in a database and you would like to copy the table to another database, use this query:. SELECT * INTO AdventureWorks.dbo.CustomersTemp FROM Northwind.dbo.Customers. Just remember that using this query will only transfer the schema and data. It does not transfer the indexes, foreign keys, statistics etc. Transfer both schema and data. Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry. Get in touch wit...

sqlservercurry.com

SQL Server Stored Procedure Recursion Limit

http://www.sqlservercurry.com/2015/03/sql-server-stored-procedure-recursion.html

SQL Server Stored Procedure Recursion Limit. In order to save you from a performance penalty, SQL Server has a hard limit set for recursion levels for Stored Procedures, Functions, Triggers and Views. The limit is 32 levels and you can’t change it programmatically. Here is a simple example demonstrating this limit:. CREATE PROCEDURE recurseProc (@cnt int) AS BEGIN PRINT @cnt; SET @cnt = 1; EXEC recurseProc @cnt; END; GO EXEC recurseProc 1;. A CTE allows up to 100 levels of recursion. There is no recursio...

sqlservercurry.com

Resolving CREATE DATABASE Permission denied in database 'master' error on Vista and SQL Express

http://www.sqlservercurry.com/2008/04/resolving-create-database-permission.html

Resolving CREATE DATABASE Permission denied in database 'master' error on Vista and SQL Express. Have you encountered the error 'CREATE DATABASE Permission denied in database 'master' even though you are logged into Windows Vista with administrator privileges. Reason for the error :. Windows Vista users that are members of the Windows Administrators group are not. Automatically granted permission to connect to SQL Server, and they are not automatically granted administrative privileges. For nine times in...

devcurry.com

Test Emails in ASP.NET without a Mail Server

http://www.devcurry.com/2011/03/test-emails-in-aspnet-without-mail.html

Test Emails in ASP.NET without a Mail Server. Element configures the local directory for a Simple Mail Transport Protocol (SMTP) server. The. Is a directory where the application saves e-mail for later processing by the SMTP server. Make sure the directory exists before using it. That’s it. Test this setting using the following code:. This is a test mail". Cool ain’t it! Just make sure that if you are using IIS, it should have read-write permissions to this folder. Will you give this article a 1? Read yo...

sqlservercurry.com

SQL Server - Find Physical Location of Records

http://www.sqlservercurry.com/2015/02/sql-server-find-physical-location-of.html

SQL Server - Find Physical Location of Records. SQL Server database files are organized in 8KB (8192 bytes) chunks, called pages. When we create the first row in a table, SQL Server allocates an 8KB page to store that row. Similarly every row in every table ends up being stored in a page. SELECT *, % physloc% AS physloc. ORDER BY physloc;. CROSS APPLY sys.fn PhysLocCracker(% physloc% ). If you are interested in knowing what’s inside the sys.fn PhysLocCracker function, use sp helptext as follows:. Declare...

sqlservercurry.com

Get SQL Server Hardware Information using sys.dm_os_sys_info

http://www.sqlservercurry.com/2015/05/sysdmossysinfo-sql-server-hardware.html

Get SQL Server Hardware Information using sys.dm os sys info. If you do not have physical access to your Database but want to get the hardware information of your SQL Server, use this query:. The sys.dm os sys info. Is available since SQL Server 2005 and contains information about server resources. For eg: you can find out the following:. How many CPUs are there in the server. Amount of physical memory available (physical memory kb -. SQL Server 2012 onwards). DNC Magazine for Developers. And a new one r...

sqlservercurry.com

Recursive Common Table Expression

http://www.sqlservercurry.com/2008/03/using-recursive-common-table-expression.html

Recursive Common Table Expression. Common Table Expression (CTE) as you know is a temporary result set defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. If you are new to CTE's, read the BOL over here. In this sample, we will see how to use Recursive CTE's to find out the Grade/Band of an employee in a company. Create temporary table called Employees. ID int Identity(1,1) PRIMARY KEY,. Insert some sample records in the Employees table. INSERT INTO #E...

sqlservercurry.com

SQL Tribal Awards

http://www.sqlservercurry.com/2014/12/sql-tribal-awards.html

Simple-Talk and SQLServerCentral.com are once again hosting the Tribal Awards. Inspired by the book Tribal SQL, the awards seek to recognize outstanding members of the SQL. Community in 11 categories. Voting is open now and will close on January 2. 2015 Winners will be announced on January 20. In the spirit of Tribal SQL, the awards will also donate £250 to the charity Computers4Africa.org at the close of the event. Link to Nomination form: https:/ www.surveymonkey.com/s/HWB5BWG. Blog of the Year. For ni...

sqlservercurry.com

SQL Server 2014: How Old is your Build?

http://www.sqlservercurry.com/2015/02/sql-server-2014-how-old-is-your-build.html

SQL Server 2014: How Old is your Build? The @ Version is a very handy T-SQL function which gives you the Major SQL Server version, the Edition (Standard, Business Intelligence or Enterprise), Build Number (RTM, Service Packs, Cumulative Update Level), Build Release Date and Windows Version. Let’s run this query along with @ ServerName which gives us the SQL Server Instance Name too. SELECT @ SERVERNAME as [SQL Server Name],. VERSION as [SQL Version]. Major SQL Server Version = Microsoft SQL Server 2014.