Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » FAQ   (RSS)

SSMS - How do I toggle the bottom pane that appears after I run a query?

CTRL - R Read More...
Posted Wednesday, October 10, 2007 12:45 PM by euanga | 1 Comments
Filed under: , ,

FAQ: Problems installing Express SP2 on a machine with ACT! installed?

Seems like Mike has the info on whats going wrong and how long it will be before its fixed. Read More...
Posted Monday, April 09, 2007 3:49 PM by euanga | 0 Comments
Filed under: , ,

FAQ: How do I query Active Directory from SQL Server?

There are several ways but the most commonly used approach of using linked servers hits ona 1000 row limit in the AD OLE DB Provider, here is a solution using SQL CLR, I have not tried it but if it works as advertised then it should help, beware it does Read More...
Posted Thursday, March 22, 2007 12:50 PM by euanga | 4 Comments
Filed under: , ,

FAQ: How do I connect to Excel 12 in SQL Server Integration Services (SSIS)

This question has been coming up a lot internally lately, short answer is: Data Source=D:\Test.xlsx;Provider=Microsoft.ACE.OLEDB.12.0; Extended Properties=Excel 8.0; Note that the provider is no longer JET but the new data engine from the office team Read More...
Posted Thursday, February 08, 2007 4:41 PM by euanga | 2 Comments
Filed under: , ,

FAQ: What impact does querying a DMV have on the system perf/load?

Linchi continues his excellent series analyzing the impact of new system features in SQL Server 2005 here . Read More...
Posted Monday, January 29, 2007 8:53 PM by euanga | 0 Comments
Filed under: , ,

FAQ: When will there be a Best Practices Analyzer for SQl Server 2005?

Soon according to Paul . Read More...
Posted Tuesday, January 23, 2007 4:25 PM by euanga | 1 Comments
Filed under: , ,

FAQ: SQL Server and Sequence Objects/Generators

SQL Server 2005 includes a lot of changes to help make moving from Oracle to SQL Server easier, these include; - User Schema separation - Multiple Active Result Sets (MARS) - Synonyms - Recursive Queries(CTEs) and some other smaller issues. However there Read More...
Posted Friday, December 08, 2006 6:00 AM by euanga | 2 Comments
Filed under: , ,

FAQ: What happens when SQL Express is installed on a machine with 2 Procs or more than 1GB of RAM

Remember SQL Express has a limitation of a single proc and 1GB of RAM (for the Buffer Pool), so can it be installed on a machine with more than those limits and what happens if it does install? In short, yes it will install just fine and once its installed Read More...
Posted Tuesday, October 03, 2006 6:00 AM by euanga | 2 Comments
Filed under: , ,

FAQ: How do I add new licenses to SQL Server 2005 or How do I change the licensing mode

In previous versions of SQL Server there was a licensing app that was integrated into control panel and was exposed via setup. It allowed you to enter the type of license you had for your server(Server+CAL or per CPU) and if you were using a CAL option Read More...
Posted Thursday, September 28, 2006 6:00 AM by euanga | 0 Comments
Filed under: , ,

FAQ: How do I import/export data with SQL Express

As a follow up to Tuesdays post , lets take a look at how this changes with SQL Express. (as always a little history) In MSDE for SQL Server 7/2000 the DTS runtime was included, this included the Package and Pump object models as well as the dtsrun tool, Read More...
Posted Thursday, July 20, 2006 6:00 AM by euanga | 27 Comments
Filed under: , ,

FAQ (With a little history), How do I copy tables with Keys and constraints from one Server/DB to another Server/db?

I see this question come up in 2 main contexts, one is express users the other is users who thought they knew how to do this in SQL Server 2000 and are now confused in SQL Server 2005. We'll start with SQL Server 2000... In general the starting point Read More...
Posted Tuesday, July 18, 2006 6:00 AM by euanga | 8 Comments
Filed under: , ,

FAQ, Why does SSMS take 45s to start up?

This is not the answer to all occurences of the issue but try the following; Shut down SSMS. Go into IE, select Tools|Internet Options|Advanced If “Check publisher’s certificate revocation” under the security node is checked, then uncheck it. Now try Read More...
Posted Tuesday, July 11, 2006 6:00 AM by euanga | 20 Comments
Filed under: , ,

FAQ: Do I have to have a named SQL Express instance to use Data Dude?

No And now the explanation. I have seen a fair number of folks having problems getting data dude running because by default it looks for a named instance of SQL Express. (I actually hit this myself when I started playing with it but I was lucky enough Read More...
Posted Thursday, June 22, 2006 6:00 AM by euanga | 0 Comments

FAQ: When does mainstream support end for SQL Server 2000?

Thanks to Peter Kalbach internally for this link . Now you will have to be on SP4 for this to be the case as support for SP3a is being retired on July 11 this year. The internal question was driven by this blog link which is obviously wrong based on the Read More...
Posted Tuesday, June 06, 2006 6:00 AM by euanga | 2 Comments
Filed under: , ,

FAQ: Why was a public hotfix just released for SP1.

Ok so this is not a true faq yet but based on previous SPs I predict it will be soon... The KB article that wraps the hotfix is here , now a little explanation. To ship an SP, which is a large undertaking for a product as large as SQL Server, at some Read More...
Posted Thursday, May 18, 2006 6:00 AM by euanga | 11 Comments
Filed under: , ,
More Posts Next page »
 
Page view tracker