Viewing 10 posts - 16 through 25 (of 25 total)
Do I have to create a linked server?
Even if I want to use the SSIS I have to do it?
I really thought Microsoft considered this scenario.
Lucas DBA
July 24, 2009 at 2:32 pm
Hello,
I want to profile and write to a table.
But in the script generated by the profiler, in the export funcionality, the following code is written:
-- Writing to a table...
July 10, 2009 at 12:59 pm
Thanks l0n3i200n
Changing the register was the only thing that solved my problem.
I used the value F (which means 15)
DBA Cabuloso
June 18, 2009 at 6:38 am
This should do:
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
BEGIN TRAN
SELECT * FROM Categories with (ROWLOCK) WHERE CategoryID = 1
...
Anyone trying to select this row will wait your transaction finish. Select *...
June 10, 2009 at 1:15 pm
The question is about the space allocated to a variable like
DECLARE @onechar as varchar(1)
DECLARE @onechar as char(1)
not to a table.
And the space allocated to both is equal.
Pay attention to the...
June 5, 2009 at 11:13 am
Nice job.
But in 2005 and 2008 you could do it using CTE (Common table Expressions) instead of dierived tables, because the script costs much time if there is a great...
June 2, 2009 at 7:33 am
The first script is incorrect therefore should be corrected.
The name of the table in the CREATE id dbInformation and in the ALTER is dbInfo.
Please correct it.
Lucas Benevides
DBA Cabuloso
June 2, 2009 at 7:00 am
I disagree
The question was:
The size of the transaction log files are physically reduced when
Physically reduced to me refers to the size of the file to the O.S. Then...
May 25, 2009 at 11:08 am
Friends,
I have just tested in the following way:
a) Created a new database in SQL Server 2005 and in the "Compatibility level" I chose 80.
b) Created a new table in this...
May 25, 2009 at 10:42 am
Viewing 10 posts - 16 through 25 (of 25 total)