Viewing 15 posts - 1,456 through 1,470 (of 9,244 total)
mw112009 (1/25/2016)
Please see attached.
The highlighted field represents my PC name.
All this time I have been connecting to other servers. This time I thought I will have something locally on my...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2016 at 11:15 am
lmacdonald (1/25/2016)
We are relatively new to clustering. We are experience a lot of failovers and was wondering if someone could help me figure out where to start looking for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2016 at 9:58 am
try this
SELECTobject_name(i.object_id)AS TableName
, i.nameAS IndexName
, STUFF((SELECT ', ' + QUOTENAME(c2.name) +
CASE ic2.is_descending_key
WHEN 0 THEN ' ASC'
ELSE ' DESC'
END
FROM sys.indexes i2 inner join sys.index_columns ic2
ON i2.object_id = ic2.object_id AND i2.index_id...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2016 at 9:55 am
mohit.699602 (1/22/2016)
Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Dec 10 2010 10:38:40
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 24, 2016 at 1:13 pm
gary1 (1/20/2016)
I have a user called USER 1 with dbcreator and securityadmin roles. He created a database DB1 and this database should be accessed by another USER 2. But he...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2016 at 8:59 pm
For me very good article, only down side was the lack of support for mounted volumes, but Ed has recognised this :satisfied:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 21, 2016 at 5:27 am
SQLSACT (1/20/2016)
Does anyone know of a way to preserve the users, assigned DB roles, owned schemas etc of a database that will be overwritten?
Scripting out the users is the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2016 at 7:22 am
Ed Wagner (1/19/2016)
Perry Whittle (1/19/2016)
ramya.sqlservr (1/19/2016)
Ed Wagner (1/19/2016)
ramya.sqlservr (1/19/2016)
We have mounted volumes on our servers and I generally use fsutil to get free...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2016 at 7:09 am
Use this rather than fsutil
wmic volume get name,capacity,"free space"
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2016 at 10:11 pm
curious_sqldba (1/19/2016)
Perry Whittle (1/19/2016)
curious_sqldba (1/19/2016)
I think i am missing something here.I am trying to connect using listener name, is that even right?
Yes you specify the listener name and the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2016 at 10:04 pm
Andrew G (1/19/2016)
vMotion only helps for hardware failure
Vmware DRS uses Vmotion to move vms around to balance usage across the hosts in an esx cluster
Andrew G (1/19/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2016 at 9:52 pm
curious_sqldba (1/19/2016)
I think i am missing something here.I am trying to connect using listener name, is that even right?
Yes you specify the listener name and the database name you wish...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2016 at 3:14 pm
GilaMonster (1/19/2016)
Perry Whittle (1/19/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2016 at 2:17 pm
An availability group may have multiple databases, you need to specify the listener name, database name and readonly intent option, then (if routing is correctly configured) you'll be redirected to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2016 at 1:39 pm
ramya.sqlservr (1/19/2016)
Ed Wagner (1/19/2016)
ramya.sqlservr (1/19/2016)
We have mounted volumes on our servers and I generally use fsutil to get free space. I want to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 19, 2016 at 1:35 pm
Viewing 15 posts - 1,456 through 1,470 (of 9,244 total)