Viewing 15 posts - 226 through 240 (of 432 total)
Digs (5/19/2010)
What do you guys do with SQL server and websites, do you have a JOB that runs and shrinks DB every 24 hours or something ???
Ouch, no! Shrink is...
May 20, 2010 at 4:23 am
Phillip - Texas (5/19/2010)
With this Cruise Control, is there a way to set rules to prevent code check-in if it doesn't pass the tests?
Not sure if CC can do that....
May 19, 2010 at 3:07 pm
muten79 (5/19/2010)
We are doing backup of the drive which contains the database every day, and we'll do one before starting the migration.
Then you may already be set up for failure....
May 19, 2010 at 2:26 pm
skjoldtc (5/19/2010)
May 19, 2010 at 1:59 pm
Use a separate sequence table ("Seq" in this example) to maintain the IDENTITY column and then populate the PO table like this:
INSERT INTO Seq DEFAULT VALUES; -- Seq has IDENTITY...
May 19, 2010 at 1:13 pm
Why not just be selective about who you give sysadmin rights to? In a typical production installation, even for a DBA there aren't many situations that absolutely need sysadmin rights.
You...
May 14, 2010 at 9:55 am
That's different to your original question. Take a look at the execution plan. See if your query is taking advantage of indexes on your tables and consider creating an index...
May 13, 2010 at 11:22 am
neliii (5/13/2010)
Hi,I got a table with 30000000 records
how much time it will take to retrive that records if i use
Select * from tablename
Why would you want to do that though?...
May 13, 2010 at 11:06 am
Just to clear up one potential point of confusion. The editorial and this thread are about O/RM (Object/Relational Mapping).
ORM[/url] (Object Role Modelling) is something entirely different and unrelated that unfortunately...
May 12, 2010 at 11:00 am
In the case of a production DBA then a possible career progression might be to a Database Manager.
For a development DBA / database professional who wants to pursue a development...
May 11, 2010 at 5:36 am
I think you didn't read the replies very well. A number of features were mentioned that are new to R2. Here's another link:
http://msdn.microsoft.com/en-us/library/bb500435(SQL.105).aspx
May 6, 2010 at 9:05 am
Not sure what you mean by "real time" in this context.
Allowing the database to autogrow regularly isn't generally a good idea because it affects performance and causes file fragmentation. It's...
May 6, 2010 at 3:58 am
A new feature of the core DBMS is Data Tier Applications (DACs). Also the Express size limitation has been increased to 10GB.
May 6, 2010 at 3:31 am
David Portas (5/5/2010)
A nonclustered index always contains the cluster key columns in the leaf pages of the nonclustered index.
Correction: it could be in the leaf level or at a higher...
May 5, 2010 at 4:48 am
Bhuvnesh (5/5/2010)
David Portas (5/4/2010)
SQLJocky (5/4/2010)
It's true that a nonclustered index always contains the cluster key columns
Here you are talking about "when the clustered index is not a unique index"...
May 5, 2010 at 4:27 am
Viewing 15 posts - 226 through 240 (of 432 total)