|
|
-
|
|
I have come across the method of finding last time the SQL server DB has been restored. I believe it would be helpful for most of us.
Please refer the link for the details.
DECLARE @dbname sysname, @days int
SET @dbname = NULL --substitute for...
|
|
-
|
|
It was announced when office 2013 preview came out so in case you missed this awesome news: "Power View is Integrated in Excel 2013!" ...
|
|
-
|
|
You can execute procedure at start up of SQL Server instance.
To do that follow steps below:
USE master;
GO
EXEC sp_configure 'show advanced option', '1';
GO
RECONFIGURE WITH OVERRIDE;
EXEC sp_configure 'scan for startup procs'...
|
|
-
10
Liked
| 10
Learned
| 10
Comments
|
|
Normally, people uses PARSENAME fuction to retrieve Server,Database,Owner and Object from four part query.
Here is another use of same to remove decimal points
SELECT PARSENAME('$12,345.00',2) -- $12,345...
|
|
-
|
|
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ser...
|
|
-
|
|
SQL Server 2012 Reporting Service provides new feature of Data Alerts by email.
For example :- Sending an email to Director of sales when any invoice having more than $250K amount....
|
|
-
|
|
I was just browsing the history of Microsoft Business intelligence when I learned that "Microsoft entered the market of OLAP tech w/ SQL server 7.0 (1998) after acquiring the technology from Panorama Software"...
|
|
-
16
Liked
| 12
Learned
| 11
Comments
|
|
Hi,
We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName.
![SSMS Hint][1]
Today , i learned another method to do the same,
**Select the query** and **right click** on...
|
|
-
|
|
A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances.
A Tool can do the things as below:
1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replicatio...
|
|
-
|
|
I needed to check where all a table is being used in a database or which objects are dependent on a table. Searched google and Pinal was on top :)
Here is the code.
SELECT referencing_schema_name, referencing_entity_name,
referencing_id, refe...
|
|