Website: www.tampasql.com <http://www.tampasql.com/> Official chapter of PASS (Professional Association for SQL Server): www.sqlpass.org...
72
swamprider5
Jun 27, 2004 10:35 pm
Does anyone use windows disk defragmenter for their sql servers? Supposedly (for win2003 anyway) disk defrag now works on open files so you do not have to shut...
73
Belina, Jeff
jbelina.rm
Jun 28, 2004 10:38 pm
There's a free e-book on Performance tuning SQL Server... http://www.veritas.com/Vrt/offer?_requestid=59464&a_id=3807& ...
74
David Fekke
davidfekke
Jun 29, 2004 1:51 pm
Microsoft just annouced that they will be giving away a limited version of SQL server 2005 to developers. ...
75
John Oakes
joakes8181
Jun 29, 2004 2:57 pm
You can actually download this now: http://lab.msdn.microsoft.com/express/sql/ I wonder if this is going to be the replacement for MSDE? -John Oakes ... From:...
76
Chris Leonard
nine_alpha_b...
Jun 30, 2004 5:25 pm
Somebody may already have responded to this (I only get the daily digest of the group), but to answer John Oakes question: yes, SQL Server 2005 Express ...
77
David Fekke
davidfekke
Jun 30, 2004 6:37 pm
I have a question for anybody else who has installed this, where are the client tools? Thank you, David Fekke. ... From: Chris Leonard...
78
Chris Leonard
nine_alpha_b...
Jul 1, 2004 1:51 pm
... I haven't installed it yet, but if it's really the latest, greatest MSDE, there might not be any. The presence / absence of the client tools is one of the...
79
David Fekke
davidfekke
Jul 1, 2004 2:38 pm
Chris, Microsoft has announce Client tools for Express. I think it is supposed to be called SQL Server Express Manager (XM). David. ... From: Chris Leonard...
80
John Oakes
joakes8181
Jul 1, 2004 4:31 pm
Does anyone have the name and contact information for the last presenter? Not the NEC people, but the guy from Vallence Solutions? Thanks! -John Oakes...
81
Randy Beyer
randy_beyer
Jul 2, 2004 6:36 pm
... presenter? ... Here you go: John Canetta office: 813-250-1900 mobile: 813-784-6248 jcanetta@... 2411 W. Horatio Street, Suite 530 Tampa,...
82
tpasql04
Jul 10, 2004 9:31 pm
We have an archive database where we offload data from the prod systems. The records are transferred once a month in big chunks:6+ GB, 10-12 hrs. for several...
83
Jeffrey R. Garbus
jeff_garbus
Jul 15, 2004 2:54 pm
I've seen this done a number of ways. Look up "Partitioned Views" in books online. It simplifies separation. If you do go with a single, indexed table, be sure...
84
tpasql04
Jul 16, 2004 1:09 am
Thank you for the sugestions; I'll try with the clustered index first. See you next Tuesday! ... separation. ... the purge ... pages, a ... (Striping, ... the ...
85
michael_bryan44
Aug 24, 2004 5:57 pm
I have two senior permanent opportunities in S. Florida. Please contact me for more details. DBA Manager (SQL Server / Sybase) - 80-90K + bonus (Full...
86
Bryan, Michael
michael_bryan44
Aug 24, 2004 5:58 pm
... **This e-mail is sent by Hudson Highland Group, Inc., or one of its subsidiaries, and may contain information that is privileged or confidential. If you...
87
djkern7277
Aug 30, 2004 1:13 pm
Hi everyone. I wanted to introduce myself and say hello to everyone. My name is David Kern. I'm sure some of you have heard the name (and, I'm sure I've...
88
David Fekke
davidfekke
Sep 10, 2004 12:29 pm
The company I work for now is looking for a real time way to write to SQL Server and Oracle at the same time. They want to know if I can write a trigger for...
89
Jeff Garbus
jeff_garbus
Sep 10, 2004 1:15 pm
You can create a linked server to oracle, & write to it. Note that it will not be transactional. ... regards, Jeff Garbus www.soaringeagle.biz 813 949 7016 (o)...
90
Pam Barker
pamiata33702
Sep 21, 2004 6:57 pm
Well guys, it's my turn to pack my bags and leave the Tampa Bay area for other opportunities. Doug Snyder is the manager of the DBA team at LendingTree.com in...
91
Bryan, Michael
michael_bryan44
Sep 21, 2004 7:00 pm
Good luck Pam. I appreciate your help in getting me set-up with the group and wish you much success in NC. Mike Bryan ... From: Pam Barker...
92
Kris Sellers
msflinxusa
Sep 22, 2004 10:57 am
Pam: After the meeting last night, looks like I am taking your position. If it is OK w/ you, I would like to meet w/ you at the PASS Conference, to discuss...
93
Pam Barker
pamiata33702
Sep 22, 2004 11:56 am
Kris, that is fabulous! I'm so glad to hear that you'll be able to take over. I felt bad about leaving the group behind, but this makes up for it. I'll follow...
94
jmorrison6914
Sep 27, 2004 7:25 pm
During the hurricane we lost a portion of our SAN where I keep the transaction logs. I need to know if there is any way to recover the database without a...
95
Jeffrey R. Garbus
jeff_garbus
Sep 27, 2004 7:28 pm
Yes. From SQL EM, detach the offending databases, then reattach them. When you reattach, it'll warn you that there's no transaction log, and then work fine. ...
96
Mike Good
mikegooddba1928
Sep 27, 2004 8:07 pm
Nice answer, concise, brimming w/confidence. ... From: Jeffrey R. Garbus [mailto:jeff@...] Sent: Monday, September 27, 2004 3:27 PM To:...
97
Jeffrey R. Garbus
jeff_garbus
Sep 27, 2004 8:18 pm
And with any luck, correct ;-) ... From: "Mike Good" <mgood@...> To: <tampasql@yahoogroups.com> Sent: Monday, September 27, 2004 1:07 PM Subject: RE:...
98
J L Morrison
jmorrison6914
Sep 27, 2004 8:38 pm
Looks like this works fine...unless you have muliple tran log files. This database has 5 files.... 2 data and 3 tran log. I am missing the 3rd tran log file....
99
Mike Good
mikegooddba1928
Sep 27, 2004 8:53 pm
Just rename the ones you have, so SQL EM can't find them. (sorry about that previous message, thought I was replying only to Jeff). ... From: J L Morrison...
100
Jeffrey R. Garbus
jeff_garbus
Sep 27, 2004 8:53 pm
Why not remove all of them? ... From: J L Morrison To: tampasql@yahoogroups.com Sent: Monday, September 27, 2004 1:38 PM Subject: RE: [tampasql] HELP! Looks...
