Forum Replies Created
Viewing 15 posts - 451 through 465 (of 514 total)
-
RE: Partition a non partitioned, existing table, is there an easier way?
Partition info is on the table, not the indexes. You have to rebuild. But if you use the Management Studio you can get it to write the script for you. ...
-
RE: Help getting rid of sql default tables
Ryan,
Apparently you are a little stressed. Couple things you need to understand.
1) This is an INTERNATIONAL Forum. There are lots of "little Foreign guys (and gals)" who read this.
2)...
-
RE: Help getting rid of sql default tables
I also agree with Steve, but I still don't recall seeing the script
I think it is obvious Ryans experience is not with... -
RE: Partition a non partitioned, existing table, is there an easier way?
The link about does tell you how to do it. However:
I feel the correct answer to your question is no, there is not an easier way.
I have to assume that...
-
RE: Misterious Change of Compatibility Level. Very urgent!
Not sure that a restore is different than an attach in the long run. The idea of the job was to narrow down the time so that you can narrow...
-
RE: TempDB Log Growth
If there are no rows, and you can truncate it, then something/someone is creating REALLY large temp files, but they are cleaning up after themselves.
Since it appears to have...
-
RE: TempDB Log Growth
Sorry, that is 2005 syntax.
USE
TEMPDB
GO
SELECT
OBJECT_NAME(id),rowcnt FROM sysindexes
WHERE
ROWCNT...
-
RE: TempDB Log Growth
This may help
USE
TEMPDB
GO
SELECT
sys.tables.NAME,SYSINDEXES.ROWCNT FROM
-
RE: birthdate as a non date field
It sounds as thought you don't have a firm requirement on the accuracy of the data, so to your point. I would still store it as a date, and record...
-
RE: how do you secure SQL against everyone?
What they said!
Even in small shops developer access to Production is risky, however you can usually deal with it. The only think you might want to grant the developers is...
-
RE: Possible to set deadlock priority on a login?
You might be able to do it with a Logon Trigger.
Trigger on a LOGON event (Logon Trigger)
CREATE TRIGGER trigger_name
ON ALL SERVER
[ WITH <logon_trigger_option> [ ,...n ] ]
{ FOR...
-
RE: Repllicate Table with no Unique ID
Sorry, I should have stated what I thought was obvious. Create a Pseudo ID using an identity column and use that column to create a primary key that allows for...
-
RE: Repllicate Table with no Unique ID
If the data is truly NOT unique in any way, then this is a case to create an identity column. The only reason for the data would be for replication...
-
RE: best practice for returning when matching a MAX()
Very interesting approach, so I put it to the test to see how efficient it really was. Sorry to say, it wasn't.
I did the following:
Table DDL: -- FYI the...
-
RE: Misterious Change of Compatibility Level. Very urgent!
I did some checking (I need to get a life). It is possible to change the compatibility level without calling the stored proc. However!!!!! it is undocumented, and unsupported. I...
Viewing 15 posts - 451 through 465 (of 514 total)