Viewing 15 posts - 136 through 150 (of 560 total)
SQL Guy 1 (3/4/2015)
1. Create 2 schemas
2. Alter them and transfer all needed tables.
3. Create 2 Fg's.
4. Create files for them.
5. For all tables in...
March 4, 2015 at 11:16 am
New Born DBA (3/4/2015)
Already Ran alter command set multi_user, but getting an error.
"Msg 5064, Level 16,...
March 4, 2015 at 11:10 am
smoham22 (3/4/2015)
March 4, 2015 at 11:06 am
nilesh_dalvi (3/4/2015)
Hi,Can we create the Database with two schema and having the separate file group for each schema.
You cannot, but ...
Why would you like to do that? Are you trying...
March 4, 2015 at 9:53 am
theboyholty (3/4/2015)
It might be worth adding that Facebook runs on MySQL and PHP with in excess of 50 million transactions per second (as of a couple of years ago anyway).
......
March 4, 2015 at 9:17 am
romanoplescia (3/3/2015)
I need a bit of advice here... I'm having an argument with our infrastructure architect who has just gone and bought lots of SSD drives to use for...
March 4, 2015 at 8:14 am
Kevin Stride (3/4/2015)
Thanks for the reply.Is granting the lock pages in memory considered best practice for Hyper-V SQL 2012?
Is there any documentation available on this?
Many Thanks
Watchout!
I also use lock...
March 4, 2015 at 7:56 am
hcip.77 (3/3/2015)
I would like your valuable input for why should i use MS-SQL Server not oracle or MySQL ?
what are strong advantages about MS-SQL Server compare to Oracle and...
March 3, 2015 at 3:02 pm
A little bit of Google magic my friend:
Searching Active Directory with Windows PowerShell
I am sure there is much more out there.
March 3, 2015 at 2:49 pm
SQL-DBA-01 (3/3/2015)
Is there anyway,can we find the list of servers by querying at active directory?
I don't think that's a good idea.
The active directory is basically a another database, a...
March 3, 2015 at 2:47 pm
I don't have much to add but ...
Very nice thread.
Very useful and insight recommendations from Jeff and interesting thread by the OP.
March 3, 2015 at 10:08 am
smoham22 (3/2/2015)
I checked nothing is running around that time. its around 12pm each day
You sure? Can you setup an extended events and capture workload at that time ?
March 2, 2015 at 5:31 pm
Spork (3/2/2015)
I was just asking in case I run into the scenario in...
March 2, 2015 at 3:03 pm
smoham22 (3/2/2015)
Client IP...
March 2, 2015 at 2:57 pm
Spork (3/2/2015)
It's my understanding that if there are jobs scheduled to run between 2:00 - 3:00 AM this Sunday...
March 2, 2015 at 2:49 pm
Viewing 15 posts - 136 through 150 (of 560 total)