Fast in SSMS, Slow in the App
- Posted in:
- SQL Server
- T-SQL
- SSMS
Your SQL Server query is fast when you run it in SSMS. It's slow in your application. But why?
[...Read More]Adding Custom Transact-SQL Code Snippets
1 Comments
- Posted in:
- Development
- SQL Server
- SSMS
- T-SQL
How to add a custom Transact-SQL code snippet to SQL Server Management Studio.
[...Read More]Transact-SQL Code Snippets
- Posted in:
- Development
- SQL Server
- SSMS
- T-SQL
Use code snippets to assist writing Transact-SQL code.
[...Read More]OPENROWSET and Quoted Data
1 Comments
- Posted in:
- Development
- SQL Server
- SSMS
- T-SQL
How to remove those pesky double quotes when using OPENROWSET.
[...Read More]
Documenting SSIS Packages
SSIS packages are pretty easy to document if your deployments are old school.
[...Read More]
Nonprintable ASCII Characters And Your Data
- Posted in:
- Development
- SSMS
- T-SQL
Nonprintable characters in your data? Egads!
[...Read More]
Formatting Dates with CONVERT
- Posted in:
- Development
- SQL Server
- SSMS
- T-SQL
Can you remember all the date and time styles supported by CONVERT? Me neither!
[...Read More]
XE Profiler - Initial Thoughts
- Posted in:
- Microsoft
- SQL Server
- SSMS
- XEvents
Initial thoughts on XE Profiler, a new feature in SSMS 17.3.
[...Read More]