Here I am working on tuning a rather large stored procedure; old school. I
have statistics IO and showplan turned on. I work through the obvious
missing indexes and improper joins and now...
2011-06-10
37 reads
Here I am working on tuning a rather large stored procedure; old school. I have statistics IO and showplan turned on. I work through the obvious missing indexes and improper...
2011-06-10
7 reads
Many years back when ASP 2.0 (not ASP.NET) was used as primary server language for web application on Microsoft platform,...
2011-06-10
752 reads
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2011-06-09
772 reads
Have you been thinking about getting certified? Are you close on finishing your studying but aren’t quite sure if you...
2011-06-09
703 reads
This is a real quick update. It has been requested that we go ahead and provide LiveMeeting for tonight as...
2011-06-09
493 reads
This is a real quick update. It has been requested that we go ahead and provide LiveMeeting for tonight as well. Thus Charley will be presenting in person but...
2011-06-09
3 reads
For those of you who’ve worked with NetApp and SnapManager for SQL Server, you will know can generate a scheduled...
2011-06-09
1,207 reads
We had a cozy (read: small) UnSQL Friday this time around, and I’m good with that. Every entry we got...
2011-06-09
842 reads
Someone asked me in a webinar how to change the default backup directory. I knew, but realized that I didn’t...
2011-06-09
24,071 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers