Viewing 15 posts - 9,526 through 9,540 (of 9,725 total)
Dinesh,
What you need is a separate data source for each individual sheet. If the max # is fixed, then you're fine. Just create a source for each possible one and...
July 30, 2007 at 4:08 am
Actually, in my original post, I did provide a better way to do it. And if a variable doesn't work for you, there's always a WHILE LOOP or a UNION...
July 26, 2007 at 8:04 am
RSI? Haven't heard that acronym before.
I hate to say it, but I can see why companies are so resistant to buying ergonomic furniture. First, it's more expensive than the...
July 26, 2007 at 5:41 am
@Thwap! @=)
My predecessor was 6 feet plus some inches tall. The desk and chair were sized for him and I couldn't wrestle the desk loose and reset it by myself. ...
July 26, 2007 at 5:13 am
Virani,
Rather than opening up a backup window from right-clicking the database and choosing "Backup", you should either use the Database maintenance Plan to create and schedule automatic backups or create...
July 26, 2007 at 4:21 am
Actually, your code is just sample code. It doesn't include a description of what you're doing with the code. And there is no real life example included with it, which...
July 26, 2007 at 4:15 am
<GROAN!> Steve, you're killing us!
@=)
Other perks, ability to work from home while waiting for the Maytag repair man / cable guy / etc.
July 26, 2007 at 4:01 am
Oh, absolutely. And you might want to check the properties of the log too, to make sure that it isn't set to unlimited growth. An out of control Translog can...
July 26, 2007 at 4:00 am
Without testing, I honestly couldn't answer you on that. And truly, I don't think there is a ratio of database to transaction log out there that is a standard.
Transaction...
July 25, 2007 at 10:19 am
I don't know, Michael. I've never seen a situation in any of the jobs where I've worked when a Cross join was needed. Usually, in fact, people are adding them...
July 25, 2007 at 9:45 am
So maybe it's not that DBAs in general are more scarce this year. Maybe it's just good DBAs that are scarce. Would that be a fair assessment?
July 25, 2007 at 8:13 am
Actually, I'm sure Backup Exec can backup open files with no problems. Open text files, .doc files, .xls files. All of which are not SQL Database files.
So you just...
July 25, 2007 at 7:50 am
Oh, I forgot to mention...
Just because the client is doing full backups doesn't mean they're doing transaction log backups. You can do one without the other (though it's not advisable). ...
July 25, 2007 at 7:34 am
Does Backup Exec actually make SQL database backups or is it backing up the .mdf and .ldf files from the server?
If the later, then your client has a problem. Databases can't...
July 25, 2007 at 7:32 am
The problem with the shopping list ads is that contracting companies take them seriously and won't submit you for a job if you're missing what they see as the important...
July 25, 2007 at 6:44 am
Viewing 15 posts - 9,526 through 9,540 (of 9,725 total)