|
|
-
Fazal Vahora Posted 1 Years ago through Just Learned | 5 Points
SQL Server 2012 launch virtual online event on 7th march 2012.
For more details
http://www.sqlserverlaunch.com/WW/Home
|
-
Fazal Vahora Posted 1 Years ago through Just Learned | 5 Points
I just learned one new thing today."How to get spatial index details with using T-SQL" check out following query.
Method #1
[code]
SELECT a.name AS Table_Name,b.name As Index_Name
FROM sys.tables a
INNER JOIN sys.spatial_indexes b
ON a.object_id=b.o
|
-
Fazal Vahora Posted 2 Years ago through Just Learned | 5 Points
I just learned one new thing today"how to know which database is used for tuning." check out following query.
[code]
USE MSDB
GO
SELECT * FROM DTA_reports_database
GO
[/code]
Result is:
[code]
DatabaseID SessionID DatabaseName
|
-
Fazal Vahora Posted 2 Years ago through Just Learned | 5 Points
I just learned today one new thing, Database Tuning Advisor(DTA) related tables and stored procedures stored in MSDB Database.
|
-
Fazal Vahora Posted 2 Years ago through Just Learned | 5 Points
I just learned today new thing,"How to delete old e-mail messages from database mail internal tables with using sysmail_delete_mailitems_sp" check out following query.
[code]
USE MSDB
GO
Exec sysmail_delete_mailitems_sp @sent_before ='2011/12/14',@sent
|
-
Fazal Vahora Posted 2 Years ago through Just Learned | 5 Points
I just learned today new thing, "How to know all database mail details like subject,body,recipients,CC,BCC,status,send date,file attachment etc.information with using catalog view sysmail_allitems." check out following query.
[code]
USE MSDB
GO
SELECT
|
-
Fazal Vahora Posted 2 Years ago through Just Learned | 5 Points
SQL Server release History:
[code]
Version Year Release Name Codename
-------------------------------------------------------------
1.0
(OS/2) 1989 SQL Server 1.0
(16bit) -
1.1
(OS/2) 1991 SQL Server 1.1
|
-
Fazal Vahora Posted 2 Years ago through Just Learned | 5 Points
I just reviewed sys.dm_db_partition_stats DMV for retrieving no. of rows exist in table,check out following query.
[code]
CREATE TABLE testdemo--Create sample table
(id int identity,
name varchar(20))
Go
INSERT INTO testdemo VALUES--Insert samp
|
-
Fazal Vahora Posted 2 Years ago through Just Learned | 5 Points
Microsoft has released cumulative update packages for both SP2 and SP3.
1. Cumulative update package 7 for SQL Server 2008 Service Pack 2
2. Cumulative update package 2 for SQL Server 2008 Service Pack 3
For more details see:
[code]
http://suppor
|
-
Fazal Vahora Posted 2 Years ago through Just Learned | 5 Points
I just learned one new thing today,you cannot create snapshot of the system databases MASTER,MODEL and TEMPDB.you can create snapshot of MSDB database with following query.
[code]
CREATE DATABASE msdb_Snapshot
ON
(Name = MSDBData,--Database logical na
|