Browse by Tags

All Tags » SQL Server (RSS)
Sorry, but there are no more tags available to filter with.
Tue, Sep 22 2009 0:05

So you want to know what version of SQL you are running on SBS 2008

So you want to know what version of SQL you are running on SBS 2008... run this query in your SQL management studio express... SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'...
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
Sun, Mar 29 2009 15:13

More tips for SQL 2008

The Official SBS Blog : Requirements for Installing SQL 2008 Standard Edition for Small Business: http://blogs.technet.com/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx To follow up on this post,...
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
Fri, Feb 13 2009 23:23

Top SQL issues from the Managed newsgroup

Top issues from the managed newsgroup Partner Online Technical Support Communities Newsgroups: https://partner.microsoft.com/US/40014662 In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT...
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
Thu, Jan 15 2009 21:29

Top SQL issues this month

In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT ISSUES =================== Issue ---------- After you added a SQL Server 2008 to 2005 cluster, you encountered the following errors: 1...
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
Thu, Jan 15 2009 21:22

How to troubleshoot SQL memory issues part II

Part two of debugging SQL server issues.... from the Partner managed newsgroups. (There's good stuff in there) (II) *Internal Physical memory pressure: SQL Server detects high memory consumption internally, causing redistribution of memory between...
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
Thu, Jan 15 2009 21:19

How to troubleshoot SQL server memory related issues (Part 1)

From the Partner managed newsgroup: This section specifically addresses low memory conditions and ways to diagnose them as well as different memory errors, possible reasons for them, and ways to troubleshoot. Background It is quite common to refer to...
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
Tue, Sep 23 2008 14:45

SQL Server 2008 Cumulative Update 1 is available

Aaron Bertrand : SQL Server 2008 Cumulative Update 1 is available: http://sqlblog.com/blogs/aaron_bertrand/archive/2008/09/23/sql-server-2008-cumulative-update-1-is-available.aspx They just RTM'd SQL 2008 and already there's an update. And ya...
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
Mon, Sep 8 2008 23:38

SQL information from the Partner newsgroups

In this Issue: TOP SUPPORT ISSUES NEW & UPDATED KB ARTICLES NEW & TOP DOWNLOADS NEW WEBCASTS RECENT SUPPORT ISSUES =================== Issue ---------- When you tied to install security update 948109, you encountered the following error: Product...
Posted by THE OFFICIAL BLOG OF THE SBS "DIVA"
Filed under:
Tue, Feb 19 2008 21:12

MSDE a memory hog....

MSDE a memory hog..... Who da thunk... not me .... Dear Susan Bradley, After extensive research and monitoring, it has been determined that the resource used by SQL express engine causes a dramatic performance decrease for the server. Futhermore, it creates...
Posted by The Official Blog of the SBS "Diva"
Filed under:
Sat, Jan 5 2008 1:59

Per my read...

http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=4&y=8 SQL 2000 falls out of mainstream support in April of 2008. If your line of business vendor is still only supporting SQL 2000, sit them down and have a talk with them. Ask them...
Posted by The Official Blog of the SBS "Diva"
Filed under:
Mon, Dec 17 2007 21:15

Keepin' up with SQL

The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released: http://support.microsoft.com/kb/937137/LN/ I have no idea what build number I have of SQL 2005 to be honest with you...but I'm losing track of 'em...
Posted by E-Bitz - SBS MVP the Official Blog of the SBS "Diva"
Filed under:
Fri, Sep 14 2007 20:38

Downgrade rights for SQL

How to downgrade to SQL Server 2000 on a computer that is running Windows SBS 2003 R2 Premium Edition: http://support.microsoft.com/?kbid=935573 Buried in yesterday's KB listing was that gem. Okay read it again.... you know what it means? I'll...
Posted by E-Bitz - SBS MVP the Official Blog of the SBS "Diva"
Filed under:
Tue, Aug 7 2007 0:59

I am such a SQL newbie it's not funny

When I go to check the mg_EmailQueue table it gives off an error and tells me to run DBCC CHECKTABLE. I am such a SQL newbie dweeb it's not funny... okay so reading this... http://msdn2.microsoft.com/en-us/library/ms174338.aspx What do I put as view...
Posted by E-Bitz - SBS MVP the Official Blog of the SBS "Diva"
Filed under: