Viewing 15 posts - 841 through 855 (of 1,583 total)
varchar() or nvarchar()
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 18, 2013 at 6:00 am
Stupeo (1/18/2013)
You can switch off schema replication?
Yes, there's an option to set the Replicate Schema Changes to false but this means every time a column is added/changed your replication will...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 18, 2013 at 5:56 am
Do you need the procedures replicated as well or just the data in the tables?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 17, 2013 at 6:48 pm
I believe your questions are answered here
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 17, 2013 at 6:44 pm
I don't think you can even buy 1TB SSD???
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 17, 2013 at 5:13 pm
Tara-1044200 (1/17/2013)
1. creating multiple tempdb data...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 17, 2013 at 3:06 pm
If you have successfully restored the DB and everything is up and running (i.e. the DB is ONLINE) there's no harm in deleting the old DB files. If either...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 17, 2013 at 9:46 am
Are you storing the data from all the SQL log files in a table on the Centralized server?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 16, 2013 at 6:23 pm
You want to add it to a scheduled job?
USE [msdb]
GO
/****** Object: Job [Automated Email] Script Date: 01/16/2013 15:25:10 ******/
IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 16, 2013 at 2:26 pm
winmansoft (1/16/2013)
So shrinking only log file will not increase the fragmentation?
Shrinking the data file will cause fragmentation within the database, and as Gail has stated, regular shrinking in general (both...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 16, 2013 at 7:38 am
ACinKC (1/15/2013)
AndrewSQLDBA (1/11/2013)
It is like asking users to type in the state name where they list. Most will get the spelling correct. Some will not.
And there's no way to limit...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 15, 2013 at 6:58 pm
Gail, I sincerely appreciate your insight. One last point to clarify:
Restore master, that will recreate all the user DBs that the old instance had (providing you left the files...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 15, 2013 at 1:23 pm
What you have will work, however as most members of this forum will tell you, it's best to use what Ola Hallengren has already perfected: http://ola.hallengren.com It's proven, accepted, and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 15, 2013 at 11:27 am
So a workable process would be to:
1. Take full backups of all User DBs and the Master, MSDB, and Model DB
2. Completely uninstall SQL Server
3. Re-install
4. Restore all User...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 15, 2013 at 11:17 am
GilaMonster (1/15/2013)
The SQL Server binaries are on a disk that you intend to replace?
yes.
Uninstall/Reinstall - This is what I thought :ermm:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 15, 2013 at 10:27 am
Viewing 15 posts - 841 through 855 (of 1,583 total)