Viewing 15 posts - 3,046 through 3,060 (of 9,241 total)
multiple posts are not helpful. Answered at this link
http://www.sqlservercentral.com/Forums/Topic1605357-3411-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 5:21 am
MickyD (8/20/2014)
What I need to achieve is an output which will go thru the table of contents and dynamically produce an output...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2014 at 4:34 am
Brandie Tarvin (8/15/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 8:00 am
to connect to 10.xx.100.745\ISH via the SQL Browser you'll need the following ports
TCP 1433, 1434, 14445
UDP 1434
To connect straight to the instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 7:54 am
hiramjamador (8/19/2014)
Anyone see any gotchas with my architecture?
Apart from the resource limitations?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 7:49 am
a quick Google search will provide all you need. Also, search the scripts section of this site for more help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 3:50 am
There are a host of extra columns available in the dashboard view. They are
Log send queue size (kb)
Log send rate (KB/sec)
Redo queue size (kb)
Redo rate (KB/sec)
Estimated data loss (time)
Estimated recovery...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 19, 2014 at 3:48 am
Have you accounted for databases with more than 1 data or log file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 17, 2014 at 3:59 am
Check Ms website for
Windows 2012 features comparison 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 8:18 am
you may use Windows 2012 Standard edition, 2012 R2 would be my recommendation
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 6:23 am
Instead of rebuilding the clustered index, I would create the clustered index with DROP_EXISTING = ON
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 4:49 am
Viewing 15 posts - 3,046 through 3,060 (of 9,241 total)