Click here to Skip to main content
15,897,371 members

Videos


Page 1 of 2
1 2


1. SQL Server: TOP…WITH TIES - A Beauty of TSQL
The TOP clause is commonly used to get the top required rows from a result set. The beauty of this clause is that it can be used with the WITH TIES clause to retrieve all similar rows to a base result set.
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 19 Apr 2013
Rating: 4.38/5 ( (8 votes))
2. SQL Server: Restore Failure from Enterprise to Standard Edition
Restore failure from Enterprise to Standard edition in SQL Server.
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 19 Apr 2013
Rating: 1.00/5 ( (1 vote))
3. SQL Server: Automatic Query Execution at Every Instance Startup
Automatic query execution at every instance startup.
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 19 Apr 2013
Rating: 5.00/5 ( (1 vote))
4. SQL Server: A Query Slow in SSMS, Fast in Application, WHY?
SQL Server: A Query Slow in SSMS, Fast in Application, WHY?
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 9 Jan 2013
Rating: 5.00/5 ( (2 votes))
5. SQL Server: Three Common DDL Change Log Methods
Three common DDL change log methods for SQL Server.
Database Development » SQL Server »
aasim abdullah Updated: 30 Dec 2012
Rating: 4.67/5 ( (3 votes))
6. SQL Server: Bookmark Lookups, a Query Performance Killer
You have place indexes but still queries are slow... are you facing bookmark lookup problem ???
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 1 Nov 2012
Rating: 4.40/5 ( (4 votes))
7. SQL Server Scripts: Get All Nested Stored Procedures List (Procedures with Dependent Procedures)
A stored procedure can be called from another stored procedure as nested stored procedure. How to get a list of these stored procedures with their nested one
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 1 Nov 2012
Rating: ( (No votes))
8. SQL Server : How to Keep Database Restore History
Backup and then restore of a database is a normal job for developers and DBAs. This script will be helpfull to findout, from which path, and which backup file a database was restored.
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 24 Oct 2012
Rating: 5.00/5 ( (3 votes))
9. SQL Server: Changed data capture without using Triggers
How to use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement.
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 23 Oct 2012
Rating: 5.00/5 ( (3 votes))
.

()
» »
Updated:
Rating: ()
10. SQL Server: Placing Alert for Compatibility Level Change in SQL 2005
In SQL Server 2005, there is no way to find out WHO AND WHEN someone changed the compatibility level of a database. Here is a trick for this functionality.
Database Development » SQL Server »
aasim abdullah Updated: 22 Oct 2012
Rating: ( (No votes))
11. SQL Server: How to Refresh Intellisense Cache
How to Refresh Intellisense Cache in SQL Server
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 20 Oct 2012
Rating: 5.00/5 ( (4 votes))
.

()
» »
Updated:
Rating: ()
12. SQL Server Management Studio: Basic Startup Options
Using SQL Server Management Studio, have you ever come a cross following questions: Why every time, a new query window is open with MASTER database.? On opening SQL Server Management Studio, I need a new query window automatically ?
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 2 Oct 2012
Rating: ( (No votes))
13. SQL Server: Get All Databases Size
A simple query to get all databases size on a given instance.
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 2 Oct 2012
Rating: 4.43/5 ( (5 votes))
14. SQL Server: Keeping Log/Alert for Job Disable/Enable Status
How do you know, if someone disabled your job at production database server. Who is the calprit. How to send a mail alert for this change ??
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 1 Oct 2012
Rating: 5.00/5 ( (1 vote))
.

()
» »
Updated:
Rating: ()
.

()
» »
Updated:
Rating: ()
.

()
» »
Updated:
Rating: ()
15. SQL Server: Disable Logon Trigger Using DAC to Resolve Login Problem
Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 17 Sep 2012
Rating: 5.00/5 ( (1 vote))

Page 1 of 2
1 2