RoKa's user avatar
RoKa's user avatar
RoKa's user avatar
RoKa
  • Member for 11 years, 1 month
  • Last seen more than 5 years ago
  • London
15 votes
Accepted

Stored Procedures under Source Control, best practice

8 votes
Accepted

How Should I Configure Memory for Multiple Instances of SQL Server?

8 votes
Accepted

How can we get table name from inside trigger?

7 votes
Accepted

SQL Server alter table to change TEXT to NVARCHAR(MAX) greatly increasing database size

6 votes

create database table with a owner in my SQL

6 votes
Accepted

How to backup databases to ensure data recovery

6 votes
Accepted

How can I search the full text of a stored procedure for a value?

6 votes
Accepted

Compress backup file using T-SQL

5 votes

Using a Having clause with an outer join

5 votes
Accepted

Getting sql statement to refer to more than 2 tables?

4 votes
Accepted

How to Drop Tables using a variable in SQL Server?

4 votes
Accepted

Get most recent 100 records from the database

4 votes
Accepted

Need to find the number of employee who are not in all department

3 votes

How to use GROUP BY after the Having clause Mysql

3 votes
Accepted

How to do division from select statements in sql server?

3 votes
Accepted

Getting error when trying to use OPENQUERY Msg 7321, Level 16, State 2, Line 1

3 votes

Main Considerations When Moving From MS Access Programming to SQL Server

2 votes

Complex query with multiple normalized fields

2 votes

Query WHERE clause and JOIN

2 votes

CPU column 5x higher on one machine vs another?

2 votes
Accepted

Give access to view or table?

2 votes
Accepted

Change SQL Server settings without restarting services

1 vote

Migration of create statement from SQL Server to MySQL

1 vote

Update a table from a join

1 vote

Query keeps on executing

1 vote

How do I rollback a dropped table using log?

1 vote
Accepted

Fixing a query that returns failed job information

1 vote

How to copy data from table to another and automatically change the values to match the other's data type msql

1 vote

SQL Server 2005 error while starting service

1 vote
Accepted

SQL Server 2008 Cluster Across Two VMWARE Hosts