Database Administrators
Profile Activity
Network profile
Robert Carnegie
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

51 Answers

Votes Activity Newest
5
How many VLF's can be bad
Jul 18 '17 at 15:43
4
Are composite primary keys bad practice?
Oct 22 '17 at 11:55
3
select a value from different tables depending on a condition
Jun 19 '17 at 16:00
2
Handle location in a SQL database
Jul 19 '17 at 20:56
2
Very large Primary Key index with few rows
Jun 25 '17 at 15:59
2
Give execute permission to user which does not have execute permission for specific stored procedure
May 30 '17 at 10:47
1
How to migrate subset of data from production to develop by scrambling sensitive data?
Oct 9 '17 at 14:16
1
SQL2008 - Alter Table Alter Column to increase length results in data loss
Jul 20 '17 at 10:00
1
MS SQL :Export data from query output to excel which has a column with huge data
Jul 19 '17 at 13:58
1
DBCC CHECKDB grows tempdb to a huge size - Legacy MS SQL Server 2008 R2 Instance
Jul 16 '17 at 11:56
1
Create an index without redundant code
Jul 11 '17 at 22:21
1
how to use complex update query, update a values in two tables
Jul 11 '17 at 10:22
1
The datediff function resulted in an overflow
Jul 4 '17 at 14:08
1
Update/fix or recreate old database
Jun 25 '17 at 15:39
1
Three update query vs single update query performance
Jun 23 '17 at 14:16
1
Red Gate comparison not working after upgrading SQL Server 2016
Jun 20 '17 at 16:25
1
I need to select only the field that has only the data
Jun 20 '17 at 12:12
1
I need to use a permenent table instead of temporary but I still need the table's data to be private to the connection
Jun 20 '17 at 11:56
1
Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
Jun 19 '17 at 16:30
1
Operators similar to 'in' that compares two sets
Jun 17 '17 at 14:26
1
Copy a row from a table to another with the same columns but different order in a trigger
Jun 16 '17 at 7:05
1
whats the use of an autoincrement primary column?
Jun 16 '17 at 0:14
1
Do I really Need to Upgrade to SQL Server 2014 SP2 ? -
Jun 15 '17 at 23:06
1
RAND in T-sql function
Jun 9 '17 at 16:34
1
Confused about behaviour of variable in WHERE statement when value is null
Jun 1 '17 at 23:08
1
Orderable representation of multi-part values
May 30 '17 at 11:09
1
Balancing history with performance
May 27 '17 at 1:31
1
Is there any security risk in having many foreign keys referencing a single table?
May 25 '17 at 17:09
1
Large Variation in Bulk Insert time
May 25 '17 at 16:32
0
I want to reset a column of the table after a month
Oct 16 '17 at 8:02
1
2