Gail Shaw

Forum Replies Created

Viewing 15 posts - 14,956 through 14,970 (of 49,552 total)

RE: Phd Suggestions

saranya.priyadharshini (1/6/2013)
Hi,
Planning to go ahead with Phd in Database Admin, Kindly provide some suggestions on it...
More efficient topic for research area is Perfomance Analysis using extended events ...
If...

January 7, 2013 at 3:22 am

#1574231
RE: Inline transaction not committing properly

matthew.peters (1/6/2013)
What I dont understand is why does it work on one database and not the other, is there a specific configuration setting that would effect this?
No, no config setting,...

January 7, 2013 at 3:18 am

#1574230
RE: Analyst seeking wisdoms while learning the platform

vega805 (1/6/2013)
I see. So for building forms, the front end to database solutions, which one is used?
Well, since ASP.Net uses .Net, that's kinda a moot question, but...
Desktop Apps, some .Net...

January 7, 2013 at 3:17 am

#1574227
RE: Inline transaction not committing properly

matthew.peters (1/6/2013)
This is all part of 1 transaction, so what I can see is happening is that the alter table statements are not committing before the insert statements.?
The committing is...

January 6, 2013 at 6:31 pm

#1574157
RE: Are the posted questions getting worse?

Stefan Krzywicki (1/6/2013)
GilaMonster (1/6/2013)
Stefan Krzywicki (1/5/2013)
In this galaxy, the laws of physics are different (the best explanation of, well, everything in Star Wars) and space there is not the (almost)...

January 6, 2013 at 3:23 pm

#1574147
RE: Index rebuild fragmentation criteria confusion

Bhuvnesh (1/6/2013)
external fragmentation is basically handled by sql server internally
No, it's not. Fixing 'external fragmentation' requires an index rebuild or index reorganise.
and data get inserted in mixed extent initially...

January 6, 2013 at 2:07 am

#1574110
RE: Index rebuild fragmentation criteria confusion

Yuri55 (1/5/2013)
It makes sense to consider internal fragmentation while making decision to rebuild indexes- why in this case majority scripts/advices (including mentioned BOL sample) do not care about it (only...

January 6, 2013 at 2:04 am

#1574109
RE: Are the posted questions getting worse?

Stefan Krzywicki (1/5/2013)
In this galaxy, the laws of physics are different (the best explanation of, well, everything in Star Wars) and space there is not the (almost) void that it...

January 6, 2013 at 2:01 am

#1574107
RE: (Restoring...) question

Run
RESTORE DATABASE <database name> WITH RECOVERY

January 5, 2013 at 3:28 pm

#1574085
RE: Performance issue due to high memory usage

SQLCrazyCertified (1/5/2013)
So, if I understand you correctly, if SQL uses all the memory which is allocated to it, then SQL will not have enough memory to work on other outstanding...

January 5, 2013 at 3:22 pm

#1574083
RE: Replacing fixed data in a WHERE clause with dynamic data

michael.newman560 (1/5/2013)
I assume that the two statements directly below the procedure name, "@inFromDate" and "@inToDate" are just two variables for the WHERE clause to use. Where do they get...

January 5, 2013 at 10:19 am

#1574057
RE: Analyst seeking wisdoms while learning the platform

vega805 (1/4/2013)
Thank you for the input Sean, Yes I want to be current. Dumb question but .NET and ASP.NET the same thing?
No.
.NET = set of libraries plus compiler and runtime
ASP.Net...

January 5, 2013 at 7:57 am

#1574043
RE: Index fregment doesn't come to 0

First problem
KcV (1/5/2013)
---- Set Recovery Mode SIMPLE
Begin
ALTER DATABASE aaa
...

January 5, 2013 at 1:55 am

#1574028
RE: Are the posted questions getting worse?

wolfkillj (1/4/2013)
jasona.work (1/4/2013)
jcrawf02 (1/4/2013)
hahaha
http://datacenterdesign.datacenterreports.com/~/media/Files/Data%20Center%20Reports/Defending%20the%20Death%20Star%20with%20a%20Little%20Data%20Center%20Design%20-%20Full%20Size.ashx
But they're cheating! They're mixing up stuff from Death Star 1 (Star Wars: A New Hope) and Death Star 2 (Star Wars: Return / Revenge of...

January 5, 2013 at 1:50 am

#1574027
RE: Record locking

Yup, that's an alternative way of doing things. Your original version we would call pessimistic concurrency (I expect someone else to try to change the same data, hence I'll lock...

January 5, 2013 at 1:48 am

#1574026

Viewing 15 posts - 14,956 through 14,970 (of 49,552 total)