Viewing 15 posts - 676 through 690 (of 789 total)
zafar (7/31/2008)
I am already using the schema's to group the tables domain wise,so what the filegroup does ??
as someone said here that you will yous for the large database environment!
:hehe:
July 31, 2008 at 4:59 am
the same post here
http://www.sqlservercentral.com/Forums/Topic542536-146-1.aspx#bm542562
plz mods merge it!
July 30, 2008 at 7:23 am
Maybe many of them... the first one is when you have the large database environment you will do some partition data in many data files so this partition is possible...
July 29, 2008 at 6:21 am
Grant Fritchey (7/29/2008)
Honestly, try reinstalling.
:hehe: I know ... this is the best solution ...just asking for any other alternative!
July 29, 2008 at 5:28 am
No, I do not have any results and I need Counting not Sum!
I posted the code what can i do in SQL Server and it works very nice, but I...
July 25, 2008 at 1:52 am
It brings to me the NULL value !!!!!!!!!!!!??????????? :w00t::w00t::w00t::w00t:
Another how to use it to see the results!
😛 LOL
July 23, 2008 at 12:49 am
nice one also ... but not in article section ...it should be in Script Section !!!:w00t:
July 23, 2008 at 12:36 am
Nice one ... short explanation very good ...how about partition in many data files not just primary!
:w00t:
July 23, 2008 at 12:33 am
There it is the code for the Tables and records ( without schema information)!
SELECT o.name AS "Table Name", i.rowcnt AS "Row Count"
FROM sysobjects o, sysindexes i
WHERE i.id = o.id
AND indid...
July 20, 2008 at 8:00 am
sreevani.chireddy what is you problem with too many posts triple posts ????
:w00t:
July 18, 2008 at 4:51 am
...ok I test right now with the TRUNCATE ( I forget it at my first post )
CREATE PROCEDURE USP_BOOM_DATA
AS
TRUNCATE TABLE TABLE_NAME1
.
.
.
.
TRUNCATE TABLE TABLE_NAME100
then
EXEC USP_BOOM_DATA
that's it!!!
But I'm sure that you can...
July 17, 2008 at 11:50 am
...And also shrinking DB after these operation is very wellcome if you use DELETE CLAUSE but you can use also TRUNCATE TABLE TABLE_NAME1..100
TRUNCATE is faster than DELETE
July 17, 2008 at 11:40 am
Viewing 15 posts - 676 through 690 (of 789 total)