Viewing 15 posts - 18,811 through 18,825 (of 19,564 total)
How about replication?
We had some procs that were once setup by the previous "dba" to be replicated. On server bounces we lost some of them.
Just a thought.
December 10, 2009 at 7:17 pm
clive-421796 (12/10/2009)
-------------------------
Have a question for you:
What if for a SQL report you want to use @StartDate AND @EndDate parameters, but also have the option for @StartHour AND @EndHour. How would...
December 10, 2009 at 3:25 pm
Aaron Bertrand has also blogged about it here.
December 10, 2009 at 3:23 pm
I take off for a few hours to work on my presentation (asked last minute to present at meeting tonight) and the thread goes berserk.
WOW.
December 10, 2009 at 3:20 pm
Greg Edwards-268690 (12/10/2009)
jcrawf02 (12/10/2009)
Steve's buying the beer, Jeff's cooking the pork chops, Gus is singing and the rest is up for grabs.
I'd imagine it might be hard to get Jeff...
December 10, 2009 at 3:18 pm
Grant Fritchey (12/10/2009)
Lynn Pettis (12/10/2009)
Roy Ernest (12/10/2009)
I dont fall under that category..I know nothing.... I know nothing... :w00t:
Dating myself here, but I actually hear Sgt Shultz from Hogan's Heros! :w00t:
Me...
December 10, 2009 at 3:15 pm
GabyYYZ (12/10/2009)
To get things started, I hope to see this thread roll over to 1000 pages before I travel on vacation. 😀
Looks like you are going to be very busy...
December 10, 2009 at 11:14 am
Reading the article I had posted should have led you to http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx. In this article it discusses the same thing that Gail has just emphasized. Reading this article...
December 10, 2009 at 10:55 am
Back to the lock pages thread
GilaMonster (12/10/2009)
Krasavita (12/10/2009)
I already have AWE check and I have Standard Edition.
If you have Standard edition of SQL 2000 then this entire conversation has been...
December 10, 2009 at 10:46 am
The best answer we could give you is: IT DEPENDS. Gail has explained it well. Now you will need to test the configs on a test server...
December 10, 2009 at 10:35 am
Guru has a good point. It may be fruitful at this point to examine the hardware to see if there is anything you can squeeze out of it.
As he,...
December 10, 2009 at 9:11 am
I went straight to a query to meet the requirements outlined rather than review the cursor. Thus I missed the datetime comparison being employed.
December 10, 2009 at 9:04 am
Jeff Moden (12/10/2009)
igloo21 (12/10/2009)
CirquedeSQLeil (12/9/2009)
Have you considered using a maintenance plan, or an SSIS package to do this?Both seem like viable alternatives as well (in addition to Steve's suggestion).
Yes I...
December 10, 2009 at 9:01 am
Viewing 15 posts - 18,811 through 18,825 (of 19,564 total)