Viewing 15 posts - 2,056 through 2,070 (of 5,590 total)
Create a "master" stored procedure. This procedure determines whether to use the parameter or not, and calls one of two appropriate procedures from there:
CREATE PROCEDURE Proc2 AS
-- procedure to run...
December 27, 2010 at 8:40 am
All of the reasons that I'm going to list are here:
Backup Compression.
Change Data Capture.
Central Management Servers.
Extended Events.
Intellisense (some love it; others loath it).
Policy-based management.
Query Multiple Servers simultaneously from SSMS.
Resource Management.
Color...
December 26, 2010 at 4:56 pm
@paul-2 - seems like the worlds been shaking down near you a lot lately... are you okay?
December 26, 2010 at 4:39 pm
In SSMS, right-click on the database and select Tasks | Import Data. Set the source to be your excel file; set the destination to be a newly created table. Import,...
December 25, 2010 at 8:18 pm
Jeff Moden (12/24/2010)
As you said, either way you still end up preping for and taking two exams. Why not take the latest and greatest?
Absolutely! (Also... almost everything you learn...
December 24, 2010 at 9:38 pm
Have you checked out the SQL Server 2008 Upgrade Technical Reference Guide?
December 24, 2010 at 9:23 am
You know, I would think that by now, you would have moved that reset button (or whatever you have to reach up near the camera) to be closer to where...
December 23, 2010 at 10:44 pm
I finally got around to creating a connect item dealing with SQL Server not honoring default data/log file locations for new databases until the service is restarted here.
I encourage all...
December 22, 2010 at 9:05 pm
FYI, I finally got around to creating a connect item for the default data/log directories not be honored until service restart here.
I encourage everyone to read it, and to vote...
December 22, 2010 at 9:03 pm
You might think about adding this index:
/*
Missing Index Details from GetChgInfoQueryPlaninSP.sqlplan
The Query Processor estimates that implementing the following index
could improve the query cost by 85.6788%.
*/
USE [SMSTHtnxTAF0]
GO
CREATE NONCLUSTERED INDEX [IX_FiscPer_RunDate_ObjId_Name]
ON...
December 22, 2010 at 6:55 pm
GElwood (12/22/2010)
December 22, 2010 at 6:47 pm
marc 96091 (12/22/2010)
GilaMonster (12/22/2010)
Please post table definitions, index definitions for the contacts table as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Sorry, I went back and added the attachments
Would you please go back and add some...
December 22, 2010 at 6:43 pm
LutzM (12/22/2010)
Here's a version that will provide the structure as requested based on Waynes sample data and sample code (Thank you, Wayne!!).
You're welcome.
However, this misses the specs every-so-slightly. What your...
December 22, 2010 at 6:20 pm
SQLkiwi (12/22/2010)
Gail is the subject of the 10th day of SQL:
Frankly, I'm surprised it took that long! (Unless we're building up to the best? That works!)
December 22, 2010 at 12:11 pm
Duplicate post. Please do not reply in this thread.
See original post here.
December 22, 2010 at 11:27 am
Viewing 15 posts - 2,056 through 2,070 (of 5,590 total)