Viewing 15 posts - 3,061 through 3,075 (of 9,253 total)
Have you accounted for databases with more than 1 data or log file
August 17, 2014 at 3:59 am
Check Ms website for
Windows 2012 features comparison 😉
August 15, 2014 at 8:18 am
you may use Windows 2012 Standard edition, 2012 R2 would be my recommendation
August 15, 2014 at 7:51 am
Steve Smith-163358 (8/15/2014)
I then ran DBCC CLEANTABLE for that table.
How long did it take to run?
What command did you use?
Did you get any error messages or info messages?
August 15, 2014 at 6:55 am
This link http://technet.microsoft.com/en-us/library/ms189835.aspx
Details
SQL Server Books Online
Specifies an additional FROM clause. This Transact-SQL extension to DELETE allows specifying data from <table_source> and deleting the corresponding rows from the table...
August 15, 2014 at 6:35 am
can you provide a little more detail on your setup, did you get any other erros during the earlier steps of the wizard.
What account type are you using for the...
August 15, 2014 at 6:25 am
It's all detailed in Books Online. Basically, the below query is aliasing a source table for the deletes and is designed to avoid a subquery.
DELETE FROM dbo.DutyRosterShift
FROM dbo.DutyRosterShift...
August 15, 2014 at 6:23 am
Instead of rebuilding the clustered index, I would create the clustered index with DROP_EXISTING = ON
August 15, 2014 at 4:49 am
Can you post results of this query please
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO
SELECTs.name
, OBJECT_NAME(o.object_id)AS TableName
, ISNULL(i.name, 'HEAP')AS IndexName
, i.index_idAS IndexID
, i.is_disabledAS IsDisabled
, CASE
WHEN i.data_space_id > 65600 THEN ps.name
ELSE f.name
ENDAS...
August 15, 2014 at 4:28 am
Lempster (8/15/2014)
August 15, 2014 at 4:05 am
Mr. Kapsicum (8/14/2014)
Anyone with the Answer.?
Patience is a virtue my friend, as well as an opera 😉
This very same topic is covered here
To explain briefly
The WITH CHECK or NOCHECK applies...
August 14, 2014 at 3:21 am
greg 69516 (8/13/2014)
I would've thought that manager would come with original package.
It does, SQL Server Express with Advanced Services 😉
August 14, 2014 at 2:36 am
naresh.talla (8/13/2014)
I want to downgrade SQL server 2008 enterprise edition to SQL server 2008 r2 standard edition, it will allow to work ? can you please help me on...
August 14, 2014 at 2:33 am
SQLRNNR (8/13/2014)
I think you mean the OP created the user as FredBloggs.
yes, sorry my bad.
In the end it's just a database user and doesn't really matter what it's called....
August 13, 2014 at 12:15 pm
The Microsoft recommendation removes any unpatched nodes from the possible owners of the VNN resource to prevent a failover causing a downgrade.
In most scenarios not all nodes are patched in...
August 13, 2014 at 12:07 pm
Viewing 15 posts - 3,061 through 3,075 (of 9,253 total)