When a Service Pack or Cumulative Update Install Fails by Evaporating
Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.
2018-12-07 (first published: 2016-01-11)
3,557 reads
Service Packs
Vote Now: Final Service Packs for 2008/2008 R2
Microsoft has continued to release Cumulative Updates, with each one specifying that customers should wait for the next service pack if they don't experience an issue. However, no Service Packs have been released for some time. Let Microsoft know we want Service Packs.
2014-03-06 (first published: 2014-02-28)
4,471 reads
2010-09-30
5,572 reads
2010-01-04 (first published: 2009-12-30)
1,687 reads
2010-01-15 (first published: 2009-12-28)
79 reads
2008-04-24 (first published: 2008-02-28)
1,835 reads
SQL Server 2000 SP 3: What's New in Security
Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.
2005-12-09 (first published: 2003-06-05)
29,991 reads
Ways to Determine the Version and SP of SQL Server
There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.
2003-02-28
21,869 reads
Another SQL Server Virus Hits the Internet
On Friday the 24th, a virus that preys on a SQL Server vulnerability began to attack networks, taking down many networks. This brief network describes the virus and how to protect yourself from it.
2003-01-27
10,796 reads
SQL Server 2000 Post SP2 Patch Released
If you're still on SQL Server 2000 SP2, beware! Microsoft has released a number of fixes that have now been rolled up into this cumulative patch to fix major security flaws in SQL Server.
2002-10-07
4,597 reads
Blogs
Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2
By MUTHUKKUMARAN KALIYAMOORTHY
How to read execution plan to improve poorly... [[ This is a content summary only....
VSCode Tips–Remove the Highlighted Line
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Use T-SQL, not the GUI
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
Forums
business intelligence development studio(Bids)
Hello, I have a SQL 2017 and I want to use business intelligence development...
MEMORY CONSUMPTION SQL 2012
hi all, as you can see in attachment sql take 122 giga memory. and...
Issue with max() and aggregate, missunderstanding
Hi all, this is my first post here and I've been looking and trying...
Ask SSC