Viewing 15 posts - 91 through 105 (of 154 total)
Valid indexing will have a far more significant effect on read performance than creating file groups.
If you need to physically separate the data for other reasons then it may be...
December 14, 2010 at 11:41 pm
Totally agree, and the Business Continuity plan should cover this in detail. People are always your key risk, be it sabotage, ransom, theft, sickness or simply absent.
November 23, 2010 at 4:04 pm
I'd have to say, with all due respect to the various posters before me, that being a Senior DBA is not a matter of whether you use the GUI or...
October 27, 2010 at 3:37 pm
So long as we can stay away from the sensationalist approach to all of this and hold a rational discussion then I'm fine.
But this does put me in mind of...
October 13, 2010 at 3:46 pm
As far as I understood is that the situation was somewhat different to the headline and Ed Bott's article on ZDNet (which is one of the rebuttal articles linked on...
October 13, 2010 at 12:58 am
Of course with SQL 2008 you can change the two inline sub-selects to CTEs for pure readability.
That would also get the effect of almost creating two tables, as various other...
October 12, 2010 at 12:55 am
Chuck Norris does not act.
We all try to act like Chuck.
September 22, 2010 at 5:07 pm
I think that this revolves around the concept that His Chuckness can do anything... even the impossible.
I would guess that the original poster is having issues with SQL on a...
September 22, 2010 at 5:03 pm
Hmm - According to the documentation here http://msdn.microsoft.com/en-us/library/ms345137(SQL.90).aspx that should have worked.
Just checking. Which version of SQL are you using?
September 15, 2010 at 4:22 pm
Nice use of REPLACE... shoulda thought of that!
September 14, 2010 at 4:39 pm
Nakul Vachhrajani (9/14/2010)
DECLARE @MyTable TABLE (MyNumericVal VARCHAR(100))
INSERT INTO @MyTable VALUES ('50.10-'),
...
September 14, 2010 at 1:38 am
For what its worth ... Hopefully it adds some flexibility
DECLARE @l_CharVal VARCHAR(20)
SET @l_CharVal = ' 50.12- '
SELECT
CASE
WHEN...
September 14, 2010 at 1:25 am
edit: ignore me, I need to read the whole thread - not just the 1st page!
September 13, 2010 at 10:43 pm
I'll second Gail on this!
RedGate tools fill a neat gap in the Visual Studio / SSMS world.
September 13, 2010 at 6:26 pm
Try taking a look at the PATH and ROOT options in the FOR XML clause.
You should be able to do this in a single select statement rather than 3...
September 13, 2010 at 6:16 pm
Viewing 15 posts - 91 through 105 (of 154 total)