Viewing 15 posts - 421 through 435 (of 2,008 total)
SQL Kiwi (1/4/2012)
Dev (1/3/2012)
But it will do a search for identical rows, if I am not wrong here as well.
Well, the rows will be in the stream anyway...
January 4, 2012 at 12:37 am
L' Eomot Inversé (1/3/2012)
GilaMonster (1/3/2012)
Divine Flame (1/3/2012)
I would request them (the bosses) again to postpone it for few weeks but don't know if they will agree :hehe:.
Well, it's that or...
January 4, 2012 at 12:29 am
SQL Kiwi (1/3/2012)
Dev (1/3/2012)
Paul, I can’t access these URLS (limited internet access 🙁 ). Would you mind sharing bullet points here?
The main point is that updates that don't...
January 3, 2012 at 11:51 pm
SQL Kiwi (1/3/2012)
I wrote about the details of 'non-updating updates' here:Also see this blog post by the SQL Server Query Optimization team:
http://blogs.msdn.com/b/queryoptteam/archive/2006/07/07/659453.aspx
Paul, I can’t access these URLS (limited internet access...
January 3, 2012 at 11:37 pm
Grant Fritchey (1/3/2012)
niclas-1082356 (1/3/2012)
...The update statement contains the exact same data as the first insert. Does sql server skip updating the indexes if the values are identical?
That is not sofmething...
January 3, 2012 at 11:34 pm
niclas-1082356 (1/3/2012)
Dev (1/3/2012)
We have a table "Person" (PersonId int PK for relations) and about 20 additional columns describing the person (Firstname, lastname, email) etc. (The fields can vary...
January 3, 2012 at 11:28 pm
However reading from a book or having a guide is always good idea but I am differing for a moment. You said you learned Oracle yourself (Bravo!) so I believe...
January 3, 2012 at 8:10 am
Vent away.....better to vent here and regain composure to discuss reocvery options.
The reason for rules is to try and avoid the chaos of disaster.
Not that they are just a reference...
January 3, 2012 at 7:54 am
GilaMonster (1/3/2012)
Dev (1/3/2012)
SQL Server will consume the memory specified in MIN memory configuration at start up.
No, it does not. Min server memory is that value that once allocated...
January 3, 2012 at 7:50 am
SQL Server will consume the memory specified in MIN memory configuration at start up. It will keep consuming more RAM if SQL Server needs for its operation & it will...
January 3, 2012 at 7:34 am
Yes. To summarize it from eyes of kid-DBA, inserts will modify all the indexes and updates will modify indexes where that particular column is defined in the index structure.
But both...
January 3, 2012 at 7:10 am
Just to make sure you installed EVAL edition only...
SELECT SERVERPROPERTY('productversion'),
SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')
January 3, 2012 at 7:08 am
How big is the table? If it’s 2 GB in size would you like to cache it? What if another reports requirement comes to you that need such dynamic data?...
January 3, 2012 at 6:58 am
Ninja's_RGR'us (1/3/2012)
Dev (1/3/2012)
Ninja's_RGR'us (1/3/2012)
Dev (1/3/2012)
Ninja's_RGR'us (1/3/2012)
Fire. Someone did an unauthorized mod on the prod server's vm (ERP 3000 employees on stand still). Now it...
January 3, 2012 at 6:43 am
Ninja's_RGR'us (1/3/2012)
Dev (1/3/2012)
Ninja's_RGR'us (1/3/2012)
Fire. Someone did an unauthorized mod on the prod server's vm (ERP 3000 employees on stand still). Now it won't even boot. ...
January 3, 2012 at 6:28 am
Viewing 15 posts - 421 through 435 (of 2,008 total)