Viewing 12 posts - 16 through 27 (of 27 total)
If you subscribe to SQL Server mag, you can find an excellent tool built by Rodney Lundrum. His really wonderful SSIS package has allowed us to begin automatically collecting and...
January 30, 2009 at 5:46 am
"The ability to communicate is very important while dealing with a DBA position in a large corporation. It's even better when that communication is easily understood and the confirmation is...
January 26, 2009 at 5:36 am
Be very careful with datetime for uniqueness. I believe the smallest time increment is 3ms. We've had this problem in the past several times. Even datetime keys...
February 4, 2008 at 12:51 pm
Be very careful even with datetime for uniqueness. I believe the smallest time increment is 3ms. We've had this problem in the past several times. Even datetime...
February 4, 2008 at 12:47 pm
Yeah, agreed, except that I don't want it to 'try to figure out'. Thanks, guys, for the verification it's not a bug. I still don't like it though. ...
January 30, 2008 at 3:16 pm
Hey, SSCrazy. That sounds good except that now I have to question the design. You're right that the alias makes it fail correctly ( isn't that ironic? ...
January 30, 2008 at 2:37 pm
Yes, it WAS an oversight. That's the problem. As I stated, the subquery on its own errors out, as expected becuse the field does not exist However,...
January 30, 2008 at 2:22 pm
Grasshopper: I have to take issue with your statement that TSQL is a horrible language. From my 38 years first as a developer and then a DBA, I...
January 25, 2008 at 7:36 am
Straegen (5/2/2005)
Not buying it. In many (read most) small companies, the dev is the SQL guy and the software developer. Most small company devs will leave TSQL quickly since working...
January 25, 2008 at 7:23 am
Using the code from the referenced article,I ran into a problem with connecting to non-default SQL Server instances. The multiserver connection bulks when I use server\instance to populate the...
November 30, 2007 at 2:15 pm
We also found that reindexing a db with 40000 tables eats log space. Optimized the process by querying sysindexes for indexes with more than xxxxx rows, then ran DBCC...
October 4, 2007 at 3:35 pm
We have a db for which the t-log grows by 10's of gigabytes overnight (wonderful PeopleSoft processing). Don't want to repeatedly shrink the file, so I'm experimenting with the...
October 4, 2007 at 3:21 pm
Viewing 12 posts - 16 through 27 (of 27 total)