Viewing 15 posts - 91 through 105 (of 631 total)
james.h291183 (1/6/2017)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
January 6, 2017 at 5:18 am
SQL Server Developer Edition is now free. You can download that locally.
http://www.microsoft.com/en-us/sql-server/sql-server-editions-developers
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
January 6, 2017 at 4:02 am
Michael Gerholdt (12/20/2016)
Do a manual failover, and now only clients on the same VLAN as the...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
January 4, 2017 at 5:41 am
Personally, I would always use a date dim for this type of thing. There are many scripts out there which should do most of the donkey work for you.
Firstly,...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 15, 2016 at 2:46 am
Would you not be licensing cores, rather than VM's?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 12, 2016 at 11:28 am
Thom A (12/6/2016)
krishnaroopa (12/6/2016)
The user has membership in db_datareader, db_datawriter and db_owner rolesThere's your problem.
db_owner's can do what every they want, whenever they want, in that database.
Slight but IMHO important...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 6, 2016 at 4:46 am
Something like this?
select
ag.Name, AGReplica.replica_server_name, ag.Group_Id, agl.dns_name as 'ListenerName', COUNT(db.database_id) 'DatabaseCount'
from
master.sys.availability_groups ag
left join
master.sys.availability_group_listeners agl
on ag.group_id = agl.group_id
left outer join
sys.dm_hadr_database_replica_states db
on db.group_id =...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 5, 2016 at 10:44 am
Sergiy (11/28/2016)
4. Vehicle registrations are not unique for a car.
You may change your car registration any day, by purchasing a personalised plate.
Not to mention - in many countries registration plates...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 29, 2016 at 8:47 am
Beatrix Kiddo (11/21/2016)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 21, 2016 at 7:15 am
Brandie Tarvin (11/17/2016)
Grant Fritchey (11/16/2016)
SP1 for 2016 (which also has CREATE OR ALTER).
A single development surface. This means all functionality in Enterprise is also in Standard and Web (WHOOOP!).
vNext...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 18, 2016 at 7:33 am
Rather than roll your own, I would use one of these
http://sqlfool.com/2010/04/index-defrag-script-v4-0/
both are great, take your pick according to your needs
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 17, 2016 at 3:21 am
I'm afraid, as ever, it depends.
If this is a staging table where you will be running a lot of transformations on the data, then the addition of an appropriate clustered...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 11, 2016 at 5:23 am
Using TRUNCATE rather than DELETE will reset the identity
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 10, 2016 at 10:33 am
When you delete rows in a heap, it can't reallocate the space it had been using.
One of the myriad ways heaps suck.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 10, 2016 at 9:28 am
Is the table a heap?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
November 10, 2016 at 9:16 am
Viewing 15 posts - 91 through 105 (of 631 total)