Viewing 15 posts - 5,716 through 5,730 (of 6,031 total)
mannaggia (2/15/2011)
I just do this:
ALTER DATABASE dbnameSET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE dbname
SET MULTI_USER
GO
Any advantage or disadvantage over the script?
I guess it depends on the conext of the situation, but...
February 16, 2011 at 8:36 am
What I like are the realestate websites where you can see actual floor plans or recorded video allowing a virtual tour. A picture is worth a 1,000 data items.
February 15, 2011 at 10:47 am
The problem is that 3rd party websites that aggregate listings from multiple sources can't be too choosy about their data, because they have no control over the data entry etiquette...
February 15, 2011 at 8:57 am
Regarding different types of database automation, I like referential integrity and check constaints, because it automatically rejects bad data at the point of insertion. Otherwise, the developer or DBA has...
February 14, 2011 at 7:36 am
Participating in forums like SSC is for database professionals what weightlifting and practice drills are for professional fire fighters. If you're fighting fires every day, then something is seriously wrong,...
February 11, 2011 at 10:55 am
Aaron N. Cutshall (2/10/2011)
James Stover (2/10/2011)
If you lie and get away with it then maybe you should consider a career in sales 🙂Or politics! 😛
Or a technical recruiter.
:rolleyes:
February 10, 2011 at 3:04 pm
lcasamen (2/8/2011)
February 9, 2011 at 7:34 am
Regarding job descriptions with too many technical requirements and resumes full of bogus experience, in many cases it's the result of a 3rd party recruiter acting as an intermediary and...
February 8, 2011 at 1:30 pm
The forthcoming version of SQL Server, codenamed "Denali" will have a sequence type object that functions similar to Oracle's sequence. However, just like an identity, it can also result in...
February 8, 2011 at 9:38 am
I think it's common (not right but simply common) for IT people to fudge the truth on their resume or during job interviews. For example, someone who has a solid...
February 7, 2011 at 9:22 am
Mammals survived the Cretaceous asteriod impact because they were warm blooded, able to immediately adapt to both warm or cold environments. That, plus the fact that they were omnivores, feeding...
February 2, 2011 at 9:08 am
The org chart says I'm a database developer, but on a normal day I spend more time writing ad-hoc SQL queries and researching data issues than I do writing T-SQL...
February 2, 2011 at 7:57 am
Regarding the issue of data breaches, I'm not much concerned about outsourcing customer service as I would be oursourcing the hosting of applications or databases. If a customer service rep...
January 31, 2011 at 7:37 am
TheSQLGuru (1/28/2011)
January 28, 2011 at 1:18 pm
sqldba_icon (1/28/2011)
Thanks Erick. So as per the first dmv in first block sum of data under "Total Mb's" should give the total amount of procedure Cache used from...
January 28, 2011 at 9:08 am
Viewing 15 posts - 5,716 through 5,730 (of 6,031 total)