 |
SQL Server Reporting Services WebCasts
|
| Total Hit (2720) |
All bold links are reporting services related webcasts
«code LangId=999»<table dir="ltr" cellSpacing="0" cellPadding="0" width="100%" border="0" id="table1">
<tr vAlign="top">
<td dir="ltr" width="100%">
<div class="clsDocBody" id="pageContainer">
<table id="table2" style="WIDTH: 100%
....Read More |
Rating
 |
|
|
|
|
|
How to create audit triggers?
|
| Total Hit (2304) |
This article will show you the most easiest way to audit your data changes for a specific table in sql server.
I will show you, how to use <Code>DBCC INPUTBUFFER</Code> command to capture some valuable audit information when update/insert/delete occurs.
Step-By-Step Example
- Run the follow
....Read More |
| Rating
|
|
|
|
How to create dynamic query without loosing performance.
|
| Total Hit (1656) |
We all know that in sql server you can use exec or execute statement to execute dynamic sql statement which can be on the fly but the biggest drawback of executing dynamic query using execute is query plan is not chached by sql server and so you get poor performance if you hitting many tables and se
....Read More |
Rating
 |
|
|
|
Serverside Paging using dynamic T-SQL
|
| Total Hit (2027) |
This stored Procedure can page records for any specified query.
«code LangId=6»
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/*
Description: Page a query. Query can have order by clause or it can pass separate orderby parameter
Examples:
=========================
[1] Defau
....Read More |
| Rating
|
|
|
|
Backup and Restore of SQL Server database using easy script.
|
| Total Hit (2769) |
In this article I will show you the most common backup/restore commands.
- How to take full backup of a SQL Server database.
- How to resore full backup over the existing/new database.
- How to restore full backup at different path over existing/new database.
<b>How to take full backup of a
....Read More |
| Rating
|
|
|
|
|
|
Check job status using T-SQL
|
| Total Hit (4880) |
You can use the following stored proc to retrive status of SQL Server job.
If user executing this SP is not in sysadmin then make sure that user has "Select" permission on <Code>msdb..sysjobs</Code> table and execute permission on <Code>master.dbo.xp_sqlagent_enum_jobs</Code> extended stored pro
....Read More |
Rating
 |
|
|
|
How to find first/last record in the group?
|
| Total Hit (4481) |
Yes this is certainly a common situation where you have to write a query to only extract first or last record from the group.
For example you might want to extract only first product from each category. Let's look at some examples.
«code LangId=6»Drop table #TempTable
Go
create table #Te
....Read More |
| Rating
|
|
|
|
|
|
|
|
Reading Text Files Into Tables with line numbers.
|
| Total Hit (2369) |
Some times we need to read text file line by line or read a specific line using T-SQL. This article will explain a simple technique using xp_CmdShell stored proc.
Let's first create a sample file which we will import into SQL Server table.
<b>test.txt</b>
«code LangId=999»<Pre>Hello this is a
....Read More |
| Rating
|
|
|
|
Importing and Exporting Data with SQL Server
|
| Total Hit (1267) |
Transferring data, whether into or out of a database, can be a complex process. SQL Server provides several tools that help you in a variety of situations, including the Bulk Copy Program, the Select statement, the Transfer Manager, and Query results. This chapter examines those options, and times w
....Read More |
| Rating
|
|
|
|
Arrays and Lists in SQL Server
|
| Total Hit (767) |
In the public forums for SQL Server, you often see people asking How do I use arrays in SQL Server? Or Why does SELECT * FROM tbl WHERE col IN (@list) not work? This text describes several methods to do this, both good and bad ones. I also present data from performance tests of the various methods.
....Read More |
| Rating
|
|
|
|
Encrypt and Decrypt Data in Yukon
|
| Total Hit (1066) |
Reports of more than 2 million credit card numbers stolen from merchants and data brokers in early 2005 brought about the expected knee-jerk reaction from federal lawmakers— new legislation that proposes to protect individuals against identity theft, such as the "Comprehensive Identity Theft Protect
....Read More |
| Rating
|
|
|
|
SQL Server 2005 Secures Your Data Like Never Before
|
| Total Hit (717) |
Right out of the box, SQL Server 2005 does not install many of its services (such as SQL Server Reporting Services) or does not have features turned on by default (.NET integration), thereby reducing the attack vectors that hackers could use to compromise your data security.
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
SQL Server 2005 Full-Text Search: Internals and Enhancements
|
| Total Hit (987) |
The full-text search feature of Microsoft SQL Server 2005 delivers enterprise search functionality integrated into the database. Significant enhancements in the areas of performance, manageability, and functionality deliver best-of-breed search capabilities for applications of any size.
This pap
....Read More |
| Rating
|
|
|
|
|
|
Statistics Used by the Query Optimizer in Microsoft SQL Server 2000
|
| Total Hit (697) |
Describes what data is collected, where it is stored, and which commands create, update, and delete statistics about indexes and column data stored in the Microsoft SQL Server 2000 database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving
....Read More |
| Rating
|
|
|
|
|
|
Using Forms Authentication in Reporting Services
|
| Total Hit (1008) |
Learn about Reporting Services security extensions with a primary focus on Forms Authentication. In addition, download and deploy a sample Forms Authentication extension for Reporting Services. (23 printed pages)
|
| Rating
|
|
|
|
|
|
|
|
|
|
Working with Reporting Services Using Microsoft Sharepoint
|
| Total Hit (1354) |
There are many instances in which the business process requires executive reports or some company performance reports to show up on intranet sites. Companies do use different portals to build their intranet sites. Microsoft’s SharePoint technology is one such tool. The main task is how we display th
....Read More |
| Rating
|
|
|
|