Viewing 15 posts - 886 through 900 (of 2,008 total)
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Just a TYPO...
sp_who [ [ @loginame = ] 'login' | session ID...
December 13, 2011 at 9:08 am
IIRC it’s not a standard term. Schema Refresh usually refers to truncating & re-populating the whole database / schema.
The following PPT explains it (with Oracle commands).
December 13, 2011 at 9:05 am
Lowell (12/13/2011)
for example, in the screenshot below, i'm...
December 13, 2011 at 8:46 am
sql_novice_2007 (12/13/2011)
The reason why I am asking this is because after testing I need to deploy these partitions on production.
I haven't created these partitions on staging.
So...
December 13, 2011 at 8:43 am
Bryan Wright (12/13/2011)
How do you find the application extension files that the upgrade advisor is seeing as an issue? It doesn't list them?
It's known behaviour.
Per BOL:
Upgrade Advisor does not...
December 13, 2011 at 8:39 am
Agree on it.
What I am thinking on following requirement, IssuerId + IssuerRecordChangeCodeDateTime is business key (assumption). Queries will be filed on business key. With the added column Optimizer has to...
December 13, 2011 at 8:31 am
GSquared (12/13/2011)
Ray Cacciatore (12/13/2011)
December 13, 2011 at 8:16 am
Sean Lange (12/13/2011)
...Another option that would accomplish both sides is to add an identity as your primary key and a unique constraint on the other two fields.
Another Column, Another Key,...
December 13, 2011 at 8:05 am
sql_novice_2007 (12/13/2011)
When I queried SELECT * FROM sys.partitions it shows 6 partitions on this table. But where I can see...
December 13, 2011 at 8:01 am
okbangas (12/13/2011)
For the partitioning to work as intended, you'll have to ensure that the partitioning key is included in the where clause of your queries.
I would recommend it otherwise. The...
December 13, 2011 at 7:56 am
DenisT (12/13/2011)
December 13, 2011 at 7:39 am
If systematic learning were all that folks knew, then things like the Tally Table, the Quirky Update, and using XML for high speed concatenation might not exist.
So they are...
December 13, 2011 at 6:04 am
Lowell (12/13/2011)
I'll be the first to say I do not know how to...
December 13, 2011 at 5:52 am
LutzM (12/13/2011)
...Not sure about the latter, but definitely the former 😀
Corrected the TYPO... ‘Tools without Technician’ and ‘Weapons without soldier’... Very Dangerous
December 13, 2011 at 5:48 am
PHXHoward (12/12/2011)
December 13, 2011 at 5:44 am
Viewing 15 posts - 886 through 900 (of 2,008 total)