Viewing 15 posts - 241 through 255 (of 608 total)
As John mentioned, we need the Actual execution plan and not the estimated plan. I also suggest not using NOLOCK everywhere.
October 9, 2013 at 4:52 am
The correct way to trace production is to use a Server Side Trace.
There is an excellent stairway series on SQLServerCentral.
October 9, 2013 at 4:37 am
sp_replmonitorhelppublication returns an extra column in 2012. If you have the latest version of DbWarden then it is most likely a bug. Try submit a ticket with the developers of...
October 9, 2013 at 3:59 am
kenneth.mofokeng (10/9/2013)
BEGIN TRY
-- Table does not exist; object name resolution
-- error not caught.
SELECT *...
October 9, 2013 at 3:19 am
Jeff Moden (10/8/2013)
Bhuvnesh (10/8/2013)
ChrisM@Work (10/8/2013)
SELECT * FROM TABLE WHERE countryid = @country
SELECT * FROM TABLE WHERE countryid = @country AND stateID = @stateid
SELECT * FROM TABLE WHERE countryid = @country...
October 9, 2013 at 2:52 am
shobanapraveen (10/8/2013)
Hi,Any one help me to insert datas into mysql.
Thanks,
Shobana
October 9, 2013 at 2:35 am
You can also use Registered Servers in SSMS.
http://technet.microsoft.com/en-us/library/ms173574(v=sql.105).aspx
October 9, 2013 at 2:01 am
Perhaps splitting it up might help
DELETE FROM fact.WorkOrder
WHERE WOStatus NOT IN ('C', 'X');
DELETE FROM fact.WorkOrder
WHERE CreateDate >= @startdate;
DELETE FROM fact.WorkOrder
WHERE CloseDate >= @startdate;
October 9, 2013 at 1:57 am
rajluves (10/7/2013)
drop index indexname on tablename
Incorrect answer to a 5 year old post.
October 8, 2013 at 1:14 am
dwain.c (10/6/2013)
Sean Pearce (10/4/2013)
Dwain, that constraint won't allow you to disable editing.
UPDATE #usTab1SET Col2 = 1
WHERE Col1 = 1;
GO
Actually Sean, I never said it would. The OP wanted to...
October 7, 2013 at 10:49 am
Jeff Atherton (10/4/2013)
What do you get with this:
select
serverproperty('LicenseType') AS LicenseType ,
serverproperty('NumLicenses') AS NumLicenses
SQL 2005+ no longer tracks licensing (per seat or per processor) via registry entries. SQL 2005 still reads...
October 4, 2013 at 7:18 am
"Enterprise Evaluation Edition" is returned for evaluation.
October 4, 2013 at 7:01 am
kevin.unglesbee (10/3/2013)
I just don't understand how it can work in the system SP, but I can't run the part of the code I want to use... please help.
SQL Server...
October 4, 2013 at 6:21 am
hoolash (10/4/2013)
Thanks Koen...but I need the BI part!
Developer Edition includes the same features as Enterprise Edition, but is limited by the license to be only used as a development and...
October 4, 2013 at 5:31 am
Does it work from the command prompt?
http://msdn.microsoft.com/en-us/library/ms188278.aspx
If not then try these suggestions
If that doesn't work then I think you need a fresh Windows install.
October 4, 2013 at 5:27 am
Viewing 15 posts - 241 through 255 (of 608 total)