What's the smartest way to keep regular backups of Microsoft SQL Server databases stored remotely?
[more inside]
posted by odinsdream
on Aug 6, 2011 -
2 answers
I'm looking for help with either SQL or with MS Reporting Services; not sure which, to be honest. I have a table of people (userID, username), a table of vegetable(s) each person bought (userID, vegatableID), and a table of fruit(s) each person bought (userID, fruitID). I'm trying to develop a report that has column A = name, column B = vegetables bought, and column C = fruits bought; I'm running into problems.
[more inside]
posted by inigo2
on Oct 27, 2010 -
14 answers
What DBA certification should I pursue? MS, Oracle, something else?
[more inside]
posted by davar
on Jan 15, 2008 -
3 answers
Microsoft Access. An SQL "GROUP BY" query. How do I generate the
mode of the values that it's grouping, when I want averages in other multiple fields?
[more inside]
posted by Jimbob
on Dec 13, 2006 -
3 answers
Attention SQL gurus. This has me completely stumped. How can I find the index (position) of a row in a table without querying the entire set?
[more inside]
posted by Civil_Disobedient
on Sep 3, 2006 -
12 answers
How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop?
[more inside]
posted by benjh
on Dec 9, 2005 -
9 answers
Say I have a database
DATA.MDB
Inside
DATA.MDB there is a table called
ImageTable.
In this table is a field named
fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example
C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all.
[more inside]
posted by Grod
on Apr 17, 2004 -
14 answers
