|
|
-
|
|
I just learned one new thing today "How to know suspected page database name,file id,page id,event type details with using suspect_pages Table which is resides in MSDB Database"
USE MSDB
GO
SELECT * FROM suspect_pages
...
|
|
-
|
|
Data viewer types can be Histogram, Scatter Plot and Column Chart - I knew just one type i.e. Grid...
|
|
-
|
|
Sometimes we need to print informations like...
Name
Address1,
Address2,
City ... etc.. in this format.
In SSRS, Put one Text Box and set expression. In expression use **VBCRLF** OR **Chr(10)**
for new line create.
e..g: "Alpesh Gorasia" & V...
|
|
-
10
Liked
| 10
Learned
| 2
Comments
|
|
Set `ARITHABOBRT` and `ANSI_WARNINGS` as OFF to handle division by Zero error
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
SELECT 1/0
This will not throw an error. Result will be NULL
...
|
|
-
|
|
As per this thread on Born to Learn ([SQL Server 2012 Certifications][1]), beta exams will go live mid-March 2012.
[1]: http://borntolearn.mslearn.net/mct/sql/f/87/p/318819/368328.aspx#368328...
|
|
-
17
Liked
| 10
Learned
| 12
Comments
|
|
Sometimes it happens that we need random row (or set of randoms rows) from table.
Itzik Ben-Gan shows us, in one of his book, the efficient way to do this:
SELECT TOP(1) * FROM someTable ORDER BY NEWID()
Changing the value in TOP operator, we can, in...
|
|
-
|
|
Learned today that converting hexadecimal values to varbinary and vice versa is easier in SQL Server 2008 compared to SQL Server 2005. MS made life simpler with SQL 2K8 :)
See below.
declare @hexstring varchar(max);
set @hexstring = '0xabc...
|
|
-
|
|
Earlier this week, one of the developers encountered issues when he tried to make a copy of the database on the server instance with a different name. He used the copy database wizard to perform this task. I was under the impression that he used the bac...
|
|
-
|
|
Today, I could not remember quickly how we check for the existence of schema in a database. This is not something I just learned, but something I forgot over the course of time. Since I don't want to rummage through my scripts or hit the web and to help...
|
|
-
|
|
This script shows how to find the beginning of current financial year (for countries using April 1 as the beginning) using TSQL.
SELECT
DATEADD(dd,0,
DATEDIFF(dd,0,
DATEADD(
mm,
-(((12 + DATEPART(m, getDate())) - 4)%12),
g...
|
|