I would look at the basics first.

1. Is there anything else other than your SQL2008R2 instance on the server?

2. Is the server a VM?

3. Does the maximum memory in your...

A test harness with DDL etc would be useful.

As this is a database why not create:

CREATE TABLE Entities

(

[Group] char(3) NOT NULL

,[Type] char(3) NOT NULL

CONSTRAINT PK_Entities PRIMARY KEY ([Group], [Type])

);

INSERT INTO...

I would start by learning RMAN as backup and restore is fundamental to the job of a DBA.

SQLDeveloper, being java based, is relatively easy to install on a Windows machine....

I have just found this link.

http://www.nomad.ee/btrieve/files/

You may be able to use some of the utilities to export from the Btrieve files without the need for Pervasive SQL.

(I presume you will...

luhar.mitul (11/5/2015)

---

Hello all experts,

Greetings !

I need your help. I work on data-migration projects and I am responsible from getting data from legacy systems to SQL Server Database.

Presently, I am...

Other things to look at are to:

1. increase the frequency of the log backups to at least every 15 minutes and automate moving the log backups to another server. This...

Looking at this again, you could also try changing:

CONVERT(DATETIME,'2015-06-05T09:29:43',126)

to

'20150605 09:29:43'

I suspect the problem is to do with the datetime column RequestDate. About 3 years ago we had some problems moving a 1990's third party program, designed to work with...

It looks as though you have precedence:

CASE

WHEN Opportunity IS NOT NULL THEN Opportunity

WHEN Campaign IS NOT NULL THEN Campaign

ELSE Account

END

Edit: Did not notice Phil's reply. His is probably better.

Manic Star (9/17/2015)

---

The other day developer asked me to create a new table that had a FK constraint to an existing largish table on the largish table's primary key.

When...

This seems to produce the required results:

WITH NameGroups

AS

(

SELECT Name, Year, Sales

,(ROW_NUMBER() OVER (PARTITION BY Name ORDER BY year) - 1)/4 + 1 AS Grp

FROM #test

)

SELECT Name, Year, Sales

,DENSE_RANK() OVER (ORDER...

You may also want to look at tranactional replication.

This should get you started:

SELECT 'REVOKE '

+ P.[permission_name] COLLATE DATABASE_DEFAULT + ' ON '

+ QUOTENAME(S.name COLLATE DATABASE_DEFAULT)

+ '.' + QUOTENAME(C.name COLLATE DATABASE_DEFAULT)

+ ' TO ' + QUOTENAME(U.name COLLATE DATABASE_DEFAULT) +...

This will not help the OP but he may want to consider it in future.

I have a non-production server where the users have a habit of dropping DBs!

I have saved...

Despite using this forum for some time you still do not seem to know how to ask a question.

Please read the following:

http://www.sqlservercentral.com/blogs/spaghettidba/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

You have been asked a number of questions and...