Viewing 15 posts - 3,841 through 3,855 (of 9,241 total)
bobbums (12/9/2013)
You do know that some of us are maintaining databases created by other people, right?
Yes, as do I.
bobbums (12/6/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2013 at 5:56 am
although generally frowned upon, xp_cmdshell can get most info from the OS. Just ensure your script disables it again after calling it like so
exec sp_configure 'show advanced options', '1'
reconfigure
exec...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 5:23 am
dan-572483 (12/6/2013)
Then why would my simple recovery model databases not come online with copies of the original log files in the new location?
The first thing you should have done is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 5:15 am
dan-572483 (12/5/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 5:09 am
Denesh Naidoo (12/9/2013)
Currently we have a stand alone SQL Server 2008 R2 Ent server. We are planning to move this environment to a Cluster. Once the cluster is ready...the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 5:01 am
mandavli (12/8/2013)
yes user I am trying does have login credential has rights to other domain server.
The account has been added to sql server as a login?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 4:56 am
mssqlnoob (12/9/2013)
frankly speaking I still could not differentiate between READ COMMITTED SNAPSHOT AND SNAPSHOT ISOLATION
The main difference is that to use snapshot isolation the query must set the option
SET TRANSACTION...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 4:54 am
bobbums (12/6/2013)
In the article, your suggestion is to drop the PK and then re-add it.
This is correct as in this case the clustered index column is also the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 4:14 am
what errors are you receiving when you try to start the agent?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 11:27 am
PHXHoward (12/6/2013)
I wrote a long detailed reply but forgot to save to clipboard before hitting submit and it didn't go through. Oh well.
Would have been interested to see that!
PHXHoward...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 11:26 am
SQLSACT (12/6/2013)
I would recommend that you put a file share witness in place
I concur
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 4:54 am
ChiragNS (10/16/2008)
Would Create Index WITH Drop_Existing work for moving non-clustered indexes.
Yes it does.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 4:26 am
ALTER TABLE [INVOICE]
DROP CONSTRAINT [INVOICE_PK] WITH (MOVE TO SECONDERYDATA)
After the move, we now recreate the PK Constraint:
ALTER TABLE [INVOICE]
ADD CONSTRAINT [INVOICE_PK] PRIMARY KEY CLUSTERED
( [column name] ASC
)WITH (IGNORE_DUP_KEY...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 4:25 am
Drop the cursors and the calls to xp_fixeddrives and fsutil and use the following
[Code]wmic volume get capacity, "free space", name[/code]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 1:19 am
Junglee_George (12/5/2013)
HiPlease explain the Difference between Now() and Today() functions in SSRS reports. Are they both same or different..??
Note that these are not T-SQL date\time events they are visual studio...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2013 at 8:44 am
Viewing 15 posts - 3,841 through 3,855 (of 9,241 total)