Viewing 15 posts - 39,946 through 39,960 (of 59,072 total)
live with a few people at work,
Heh... shoot... why would I want to do that? I see them too much as it is. If you want productivity to...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 8:37 pm
Tara-1044200 (2/2/2010)
I dont have any indexes on any tables in that database.Can you some one give correct explanation as to why space is not released when some column are deleted?
Tara-1044200...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 8:23 pm
Restricting xp_CmdShell is probably a good idea but proxies can be setup to allow calling of stored procedures that use it without exposing xp_CmdShell to most users. I don't...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 7:58 pm
I'm going with Elliot on this one. It sounds like a classic memory leak either caused by an app, a CLR (whatever you want to call it), or perhaps...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 7:55 pm
lmu92 (2/3/2010)
If you want to see all order numbers with different values then you could use something like the following (untested,...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 7:46 pm
Perhaps include a fully qualified schema name instead of just "dot dot"?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 7:00 pm
Welsh Corgi (2/3/2010)
Have you tried using a format file with the BCP Utility?
I believe that Welsh's idea above could be one of the simplest and fastest ways. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 6:56 pm
xp_CmdShell (I believe) but why would you want to do that?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 6:50 pm
BaldingLoopMan (2/3/2010)
---------------------------------------------------------------------
CREATE FUNCTION dbo.Split
(
@RowData...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 5:48 pm
Shark Energy (2/3/2010)
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 5:30 pm
It's real hard to come up with a more meaningful post on this subject than what the two of you have already so I'll leave my rant about this right...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 5:27 pm
Ohhh... be careful. I just went through a similar thing a month ago. Having an index with a leading column having only two possible states will sure speed...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 5:05 pm
I still think it would be a great article. Lots of people run into the same problem.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 4:37 pm
GilaMonster (2/3/2010)
Um....
Heh... that one brought back some bad Oracle discussion memories.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 4:32 pm
Roy Ernest (2/3/2010)
GilaMonster (2/3/2010)
http://www.sqlservercentral.com/Forums/Topic856967-1291-1.aspx
Seriously, where are all the idi^H^H^H novice-type people...
--Jeff Moden
Change is inevitable... Change for the better is not.
February 3, 2010 at 4:23 pm
Viewing 15 posts - 39,946 through 39,960 (of 59,072 total)