sql version? From: tampasql@yahoogroups.com [mailto:tampasql@yahoogroups.com] On Behalf Of Jim Pennington Sent: Thursday, August 27, 2009 3:28 PM To:...
You don't specify a SQL Server Version, but this will work on 2000, 2005, 2008. If you are on 2005/2008, there are better queries using the DMV's though: ...
Sp_helpindex From: tampasql@yahoogroups.com [mailto:tampasql@yahoogroups.com] On Behalf Of Jim Pennington Sent: Thursday, August 27, 2009 3:28 PM To:...
Brian Hollister
bhollister@...
Aug 27, 2009 8:01 pm
377
Yesterday PASS unveiled its new forum for hotel/travel information for the PASS Summit. If you're going to Summit this year I highly recommend you take a look...
Does anyone know the difference between these two methods of Restarting sql server? Which is more likely to succeed? 1) From SQL Server Management Studio:...
Off-hand I don't believe there's a difference between the two methods. Under the covers its pretty much calling the same commands (I'd imagine). I'll rifle...
They both use WMI to control the services. There is fundamentally no difference. Jon Kehayias SQL Server MVP Founder SQLCLR.net (http://www.sqlclr.net) ...
See below for details about next week's SQL Lunch presentation. ... From: LeBlanc, Patrick <pleblanc@...> Date: Thu, Sep 10, 2009 at 2:34 PM Subject: SQL...
Thanks Jorge and Jon. But obviously my question was not worded properly to get the information I was seeking. Issuing sql a start command is the easy part....
Personally, I wouldn't let my SQL Server auto restart like that, and it's not a recommended practice by Microsoft either. If the service crashed, something is...
The link to the free eBook copy of Grant Fritchey's, SQL Server Execution Plans is: http://www.red-gate.com/specials/Grant.htm?utm_content=Grant080623 If you...
Hello all! I just wanted to pass this along. For those who don't know about the PASS Virtual Chapters, they are online versions of our user groups only they...
The next SQL Lunch event is coming up on Monday. See below for details. ... From: LeBlanc, Patrick <pleblanc@...> Date: Fri, Oct 2, 2009 at 10:22 AM ...
Hey all just wanted to share this with everyone in case anyone was interested in setting one up here. Chris Randall of the Denver SQL User Group put up details...
That sounds like a great idea! Would the group be working towards 2005 or 2008 certifications? Travis ... From: Jorge Segarra <jorge.segarra@...> Sent:...
If there's enough interest to form a group I guess that'd be something to decide -Jorge Segarra ... If there's enough interest to form a group I guess that'd...
Hey all, Tonight I was talking with some folks about horror stories from work from people not following bet practices. This past week Aaron Bertrand has been...
If you're interested in learning more about dynamic management views (DMVs) in SQL Server 2005/8, this webcast will be a good opportunity. It's going to be...
Hello all! How many of you would like to play around with SQL 2008 and all its goodies but don't have a dedicated environment to do so? Well now you can and...
We have an Enterprise Datacenter Edition of Server 2003, running SQL Server 64bit Enterprise. We are running 16gb of memory and have been told that we have...
You are correct, this is not true for 64-bit SQL. We're not enabling AWE on any of our 64-bit SQL Servers, and are able to access all the memory we want. And...
You should have lock pages in memory set in the local security policy, but you don't need awe enabled on 64 bit. I'll send a link to references when I get...
Your consultant is off base. You don't need AWE, you can choose to enable Lock pages in memory if you choose. If it is a standalone server with one instance...
For 64bit servers, the VAS is software limited at 7/8TB for user mode VAS versus 32 bit servers which had a 4GB VAS split by default 50/50 into user and kernel...
While we're on the subject of memory, can you provide any advice regarding the size of the pagefile on a 64-bit server? MS released a KB on this but I didn't...
This was discussed a while back by the MVP's with Microsoft. The answer ... The only thing you won't get by not having 1.5X memory for the page file is a full...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
