Viewing 15 posts - 646 through 660 (of 1,048 total)
wemorganjr (2/22/2011)
I have a database which will not return a simple ‘SELECT Count(*)FROM dbo.APProduct’.
I am not exactly sure what you mean by this... like does it fail, or return...
February 22, 2011 at 8:35 am
The fact that the linked servers security context are configured exactly the same on both instances doesn't mean a thing.
To illustrate my point, lets say instance A is installed under...
February 18, 2011 at 10:19 am
when you create a linked server you have several option regarding how to deal with connection authentication to the linked server. You will need to configure the method of...
February 18, 2011 at 8:54 am
The issues you are dealing with involve logins and database users and how they are mapped as well as roles, schemas and permissions.
If you are going to be doing...
February 16, 2011 at 3:00 pm
Why not change the recovery mode to full and start doing hourly translog backups for a week. That should give you an idea of data volume and peak activity times/days.
February 16, 2011 at 12:40 pm
Glad to be of assistance. good luck
February 16, 2011 at 8:40 am
here is a short example of a batch file variable being set via user input (from a prompt at run time) then the variable being used in subsequent commands:
rem prompt...
February 16, 2011 at 8:05 am
I have typically handled this by using batch script (.bat) files. Assuming you are using a Windows platform, the command shell is plenty flexible enough for you to prompt for...
February 16, 2011 at 7:33 am
generally speaking there is no need to change the db owner just because the person no longer exists. The database will be perfectly happy to be owned by the original...
February 11, 2011 at 8:50 am
here are the basic steps:
1. requirements document
2. design specification (here is where you define database objects)
3. test plan document
4. development
5. test
6. beta release
7. final release
Everything follows step 1. some of...
February 10, 2011 at 2:50 pm
"Now just help me decide.. should i keep on studying or Hire those Architect, Police man, Engineer etc etc to build me a House (AKA Database)"
You bring up an excellent...
February 10, 2011 at 2:27 pm
you need a left join on the Course table like this:
SELECT SUM(CASE WHEN Student_ID IS NULL THEN 0 ELSE 1 END) AS StudentCount, Grade_Description
FROM Student s
RIGHT OUTER JOIN Grade g...
February 10, 2011 at 1:21 pm
The only comment I might make is to say that actually creating the database and the objects within it are probably the most trivial part of the entire project.
To use...
February 10, 2011 at 12:45 pm
For one thing, if you have 3 instances on the same server they can't all be using the same mdf files, unless all servers are an exact duplicate. Besides, the...
February 10, 2011 at 12:22 pm
Okay, now I understand what you want to get. Try it this way:
SELECT SUM(case when Table1.Field1 is NULL then 0 else 1 end) AS MyCount, Table2.Field1 FieldA, Table3.Field1 FieldB
FROM Table1...
February 10, 2011 at 12:11 pm
Viewing 15 posts - 646 through 660 (of 1,048 total)