Keep it Simple and Smart
Microsoft has released one second draft of this book. PART I DATABASE ADMINISTRATION (Ross’s part) Denali Editions and Enhancements High Availability and Disaster Recovery Enhancements Scalability and Performance Security Enhancements Beyond Relational PART II BUSINESS INTELLIGENCE DEVELOPMENT (Stacia’s part) Integration Services Data Quality Services Master Data Services Analysis Services and
» Read moreIn SQL Server 2012, seven new datetime functions have been introduced. EOMONTH is one of them. This is really useful function because many times we need to find the last date of month. Syntax: EOMONTH ( start_date [, month_to_add ] ) Find Last Day of Current Month Example: SELECT EOMONTH
» Read moreIn SQL Server 2012, seven new datetime functions have been introduced. DATEFROMPARTS is one of them. Syntax: DATEFROMPARTS (year, month, day) DATEFROMPARTS returns a date value with the date portion set to the specified year, month and day, and the time portion set to the default. If the arguments are
» Read moreThere are seven new datetime functions are introduced in SQL Server 2012 as motioned below DATEFROMPARTS ( year, month, day) DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds ) DATETIME2FROMPARTS ( year, month, day, hour, minute, seconds, fractions, precision ) DATETIMEOFFSETFROMPARTS ( year, month, day, hour, minute, seconds, fractions,
» Read moreWhile restoring the SQL database error occurred… Through UI following error occurred Through Script following error occurred Script: RESTORE DATABASE mydb FROM DISK = 'D:\ DB Backup\mydb.bak' WITH MOVE 'mydb_Data' TO 'E:\Database\mydb.mdf', MOVE 'mydb_Log' TO 'E:\Database\mydb.ldf', REPLACE GO Msg 3203, Level 16, State 1, Line 1 Read on “D:\ DB
» Read moreSometime we faced the following error message while restoring the database Error 3154: The backup set holds a backup of a database other than the existing database. Solution: Use WITH REPLACE while using the restore script as Script 1 RESTORE DATABASE YourDB FROM DISK = 'C:\YourDB.bak' WITH REPLACE Script 2
» Read moreGO is not a Transact-SQL statement, even it used in the Transact-SQL. It is a SQL Utility command. SQL Server utilities interpret GO as a signal that they should send the current batch of Transact-SQL statements to an instance of SQL Server. The current batch of statements is composed of
» Read moreThis function “sp_trace_setstatus” modifies the current state of the specified trace. Syntax sp_trace_setstatus [ @traceid = ] trace_id , [ @status = ] status Example –See the Ruuning trace SELECT * FROM ::fn_trace_getinfo(NULL) — Stop thr Running Trace EXEC sp_trace_setstatus @traceid = 1 , @status = 0 — Delete the
» Read moreFn_virtualfilestats() is in-build function in the SQL Server and really useful for understanding the amount of I/O within individual files on your SQL Server system. It returns I/O statistics for database files, including log files. Syntax fn_virtualfilestats ( { database_id | NULL } , { file_id | NULL } )
» Read moreWe can find the wait stats as posted here We can Reset or clear the wait stats using — Reset or clear the wait stats counter DBCC SQLPERF (waitstats, clear) Hope this will help you.
» Read moreVarinder Sandhu is using WP-Gravatar