Grant Fritchey

Forum Replies Created

Viewing 15 posts - 13,831 through 13,845 (of 22,213 total)

RE: Are the posted questions getting worse?

Jeff Moden (12/5/2010)
Heh... I found a way around all of the "problems" with WordPress... I write articles on SQL Server instead of blogging. 😛
You may be on the right side...

December 6, 2010 at 5:30 am

#1258957
RE: Data Model and Domain Model Implementation (Many-to-Many Relationship)

robertlewis2001 (12/4/2010)
Hello,
I'm quite confused about how to implement a many-to-many relationship and my domain model. Let's say I'm creating a recipe box web application and I have three tables called...

December 5, 2010 at 5:23 am

#1258812
RE: Are the posted questions getting worse?

Luke L (12/3/2010)
Grant Fritchey (12/3/2010)
Steve Jones - SSC Editor (12/3/2010)
Alvin Ramard (12/3/2010)
I have a confession to make.
While setting up WordPress yesterday, I had to create a MySQL database.
I hope y'all...

December 3, 2010 at 10:46 am

#1258552
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (12/3/2010)
Alvin Ramard (12/3/2010)
I have a confession to make.
While setting up WordPress yesterday, I had to create a MySQL database.
I hope y'all will forgive me. ...

December 3, 2010 at 9:18 am

#1258483
RE: Export with Headers

Steve Jones - SSC Editor (12/3/2010)
Be good to have one in Powershell, and while we're at it, anyone want SQLAzure?
Right, I'll do one in PowerShell, but no promises on deliver...

December 3, 2010 at 9:13 am

#1258480
RE: Are the posted questions getting worse?

Alvin Ramard (12/3/2010)
I have a confession to make.
While setting up WordPress yesterday, I had to create a MySQL database.
I hope y'all will forgive me. 😛
Hope everyone is having a...

December 3, 2010 at 9:03 am

#1258469
RE: Set Up And Schedule a Server Side Trace

ALZDBA (12/3/2010)
Jack Corbett (12/3/2010)
jason.spangler (12/3/2010)
I stand corrected everyone. Sorry about the incorrect information. I was told in a class that it had to be cleaned up, and never...

December 3, 2010 at 7:47 am

#1258417
RE: Set Up And Schedule a Server Side Trace

CirquedeSQLeil (12/2/2010)
Great Stuff Grant.
Thanks Jason.

December 3, 2010 at 5:52 am

#1258332
RE: Set Up And Schedule a Server Side Trace

Jeff Moden (12/2/2010)
Good stuff as always, Grant! Thanks for taking the time to write articles like this. This one should be in every DBA's quick reference guide. 🙂
Thanks...

December 3, 2010 at 5:51 am

#1258330
RE: Export with Headers

Jeff Moden (12/2/2010)
Grant Fritchey (12/2/2010)
For the non-SSIS version, what language are you using? Because if it's not PowerShell, I might want to do one using PowerShell.
Steve asked for "using bcp,...

December 3, 2010 at 5:43 am

#1258328
RE: Set Up And Schedule a Server Side Trace

Jack Corbett (12/2/2010)
ALZDBA (12/2/2010)
I haven't noticed it would not cleanup the trace def in systraces after the end time.
Tested in SQL2000 / SQL2005 / SQL2008R2 CU4 .... ehm .... yes...

December 2, 2010 at 6:31 pm

#1258177
RE: How do I know when to use temp tables/table variables?

Craig Farrell (12/2/2010)
SQLNW (12/2/2010)
Thank you Wayne, I am thinking why do we use temp table in the first place? As soon as you see a problem how you decide you...

December 2, 2010 at 1:28 pm

#1258097
RE: How do I know when to use temp tables/table variables?

SQLNW (12/2/2010)
Thanks so much Grant. I have a silly question. when do you actually know when to use temp table concept in the first place, I mean if you look...

December 2, 2010 at 1:27 pm

#1258095
RE: Set Up And Schedule a Server Side Trace

CavyPrincess (12/2/2010)
Grant Fritchey (12/2/2010)
Writing to file is much, much faster than writing to a database, so yes, it does make a difference. Also, is that database on the same server...

December 2, 2010 at 7:49 am

#1257898
RE: Set Up And Schedule a Server Side Trace

PAH-440118 (12/2/2010)
What is the command to delete to the trace definition?
Right here in the Books Online:
1.Execute sp_trace_setstatus by specifying @status = 0 to stop the trace.
2.Execute sp_trace_setstatus by specifying @status...

December 2, 2010 at 7:15 am

#1257865

Viewing 15 posts - 13,831 through 13,845 (of 22,213 total)