SQL Server – Login Failed, cannot open user default database
Each login in SQL Server has a default database associated with it. When you login to SQL Server context is...
2013-01-07
1,809 reads
- Interests: SQL Server!
SQL Server – Skipping Function Execution when parameters are NULL
You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create...
2012-12-28 (first published: 2012-12-19)
4,119 reads
SQL Server – DDL vs. DML Triggers
Although, DML and DDL triggers are used for different purposes, there are some similarities and differences between these.
Similarities between DDL...
2012-05-28
1,631 reads
SQL Server – Check SQL Agent Job History using T-SQL
To check SQL Server Agent Job History you can use the Log File Viewer from SQL Server Management Studio.
To Open...
2012-05-14
2,837 reads
SQL Server – Purging Database Mail History
SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove...
2012-05-10
1,246 reads
SQL Server – Four-part object names
Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion...
2012-04-30
3,143 reads
Run SSMS as different Windows user
When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used...
2012-04-23
2,425 reads
Microsoft Certified Solutions Associate – SQL Server 2008 Core / Windows Server® 2008
Yesterday, I received two mails from the Microsoft Certification Program Team about two new certification earned:
1. Microsoft Certified Solutions Associate...
2012-04-18
1,715 reads
Importing data from Excel – using INSERT statements
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However,...
2012-03-29
3,313 reads
Exporting data to CSV file using SQLCMD/BCP
When it comes to exporting data there are different options available in SQL Server, such as SQL Server Integration Services,...
2012-03-27
4,816 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
FARE Lab's Leading FSSAI Third Party Auditing Services
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
FARE Labs is The Leading FSSAI Third Party Auditing Services of India.
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers