Viewing 15 posts - 7,066 through 7,080 (of 7,597 total)
select
PARSENAME(left(email, charindex('@', email) - 1), 1) + '.' +
PARSENAME(left(email, charindex('@', email) - 1), 2) +
substring(email, charindex('@',...
November 20, 2012 at 9:33 am
SQL Server has frankly always had some internal issues with parallelizing queries. Parallelization is great for (re)building indexes, but for queries it's always had its quirks.
Unless you are absolutely...
November 19, 2012 at 5:39 pm
delete from #ExistingBackups
where
(Name not like '%master%' and Name not like '%model%' and Name not like '%msdb%') or
(ISNUMERIC(Right(SUBSTRING(name,1,charindex('.',name)-1),8))=0) or
...
November 19, 2012 at 3:33 pm
ahthomas (11/19/2012)
November 19, 2012 at 3:29 pm
ocolakoglu (2/8/2011)
HiWhen i use change data capture can i log hostname,username information?
You can use any columns from the original table you want ... but that's it.
So to capture that...
November 19, 2012 at 3:23 pm
fluffydeadangel (11/19/2012)
my simple goal is to create a two part job that will reindex only the items that need it ...
select 'ALTER INDEX ALL ON dbo.' ... 'FILLFACTOR = 80'...
November 19, 2012 at 3:20 pm
Other than the final ORDER BY, I think the query below will do it.
Personally, I wouldn't rewrite your existing query any more than you have to to make it do...
November 19, 2012 at 3:06 pm
I too think nested REPLACEs would probably be fastest.
You could do a simple function, but I'm not sure that would perform as well, let alone better ... but, really, with...
November 16, 2012 at 5:21 pm
No, normally you never change an identity/key value in a warehouse once it's been assigned. I can't imagine anything that would require that to be done, so it's very...
November 16, 2012 at 4:59 pm
No, normally you never change an identity/key value in a warehouse once it's been assigned. I can't imagine what would require that to be done.
November 16, 2012 at 4:58 pm
The TRY block will be fully parsed and begin execution before the CATCH block is processed, so, yes, all variables in the TRY block will be made available to the...
November 16, 2012 at 4:55 pm
Bobby Glover (11/9/2012)
November 9, 2012 at 2:35 pm
To be safe, you probably want to add the length of the clustering key to the column to be ALTERed.
So, for example, if the clus key is 4...
November 9, 2012 at 1:03 pm
ScottPletcher (11/8/2012)
AndrewSQLDBA (11/8/2012)
I just saw some of the data as only 3 digits. So 499 would need to be converted to 499.00 etc.....
There may also be...
November 9, 2012 at 8:44 am
Hmm, it's not clear to me what "fields" 2 and 3 contain, so I'll assume field2 has the "4Q" and field3 has "12".
Just in case field1 is indexed, or it...
November 8, 2012 at 5:19 pm
Viewing 15 posts - 7,066 through 7,080 (of 7,597 total)