|
|
-
|
|
Generating multi-part names (four-part, three-part or two-part) for database objects and interpreting them can be labour intensive at times. This post provides scripts that can be used to reduce the manual effort required for these activities...
|
|
-
|
|
Without executing this query, can you find out the output?
select _________ name from
(
select 2e4 _________
) t
...
|
|
-
|
|
A few days before, i just posted one article to check running scheduled jobs and i used master.dbo.xp_sqlagent_enum_jobs system objects and joined with dbo.sysjobs object from msdb database for same. Please read that post before moving down. This was on...
|
|
-
|
|
This will explain how to implement Import wizard step by step with an example...
|
|
-
|
|
Most database documentation and code fail to address name resolution errors – i.e. the ability to ensure that a name uniquely identifies a database object. This post provides an introduction to four-part, three-part and two-part database object naming conventions....
|
|
-
|
|
Microsoft SQL Server Integration Services and it's Architecture....
|
|
-
|
|
What do we mean by Microsoft Business intelligence suite and it'scomponents- SSIS,SSAS,SSRS?...
|
|
-
|
|
Data security is the cornerstone of every business application. There is no arguing to the fact that confidential information needs to be protected by overlapping layers of security. Another aspect of security is data integrity....
|
|
-
|
|
What do we mean by Business Intelligence and how we can achieve an Intelligent Business?...
|
|
-
|
|
RAND function in SQL Server is used to generate a random value between 0 and 1. When you use RAND in the SELECT statement, it generates the same value for the entire resultset. One of my friends asked me if it is possible to have different random values...
|
|