|
|
-
|
|
Both `SP_who` and `SP_who2` provides information about the current processes/sessions/users in an SQL servert instance.
- `SP_WHO`:
`SP_WHO` provides information like Session ID, Logged in User id , Host name, session status, blocking ...
|
|
-
|
|
There are 2 Set Options available to only parse the SQL Statements.
> 1.
SET PARSEONLY ON;
GO
SELECT * FROM TableName;
GO
SET PARSEONLY OFF;
GO
> 1.
SET NOEXEC ON;
GO
SELECT * FROM TableName;
GO
SET NOEXEC OFF
> 1. Option only give schema of Tabl...
|
|
-
|
|
There is no implicit conversion on assignment from the sql_variant data type to other, but there is implicit conversion to sql_variant.
SQL_VARIANT is a data type that stores values of various SQL Server-supported data types.
ODBC does not fully suppo...
|
|
-
|
|
SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950.
SQL Server also provides cutoff configurations but Microsoft recommend using 4...
|
|
-
|
|
Any SSRS report is not re-displaying the changed information when running the same report back-to-back, even though the report itself is set with the following in the SSRS setup:
Always run this report with the most recent data, Do not cache temporary c...
|
|
-
|
|
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|
|
-
|
|
I like the integration of SSIS and DQS. It's a great way to automate cleansing of data. while exploring further, I learned that currently, DQS does not expose matching functionality for SSIS to use but I guess I'll have to try Fuzzy Grouping Transform t...
|
|
-
|
|
Today my colleague came up with a problem that he were not able to restore database having error like follows.
Restore failed for Server ''. (Microsoft.SqlServer.Smo) System.Data.SqlClient.SqlError: The file "D:\Db.mdf" is compressed but d...
|
|
-
|
|
Found another good reason to avoid using IN clause in your TSQL Queries. See the example below:
create table #temp
(
a int ,
)
create table #temp1
(
b int ,
)
INSERT #temp VALUES(1)
INSERT #temp VALUES(2)
INSERT #temp1 VA...
|
|
-
|
|
There are four schedule types.
1. One Time : It executes once as per the schedule
2. Recurring : It is recurring type and execute on specified interval on specified time till schedule end.
3. Start when CPU Idle : It executes when CPU is sufficient f...
|
|