Viewing 15 posts - 47,041 through 47,055 (of 49,571 total)
Sandy (4/2/2008)
Can any body clear me how many characters allowed in varchar(8000) and nvarchar(4000)?
VARCHAR(8000) = 8000 characters.
NVarchar(4000) = 4000 characters (each taking 2 bytes)
April 2, 2008 at 3:24 am
You can use the estimated execution plan. Just bear in mind it is an estimate. If you're running into parameter sniffing problems (which from the sound of things you might...
April 2, 2008 at 2:12 am
And you can use sp_helptext to get their definition as well.
EXEC sp_helptext 'sys.objects'
April 2, 2008 at 1:50 am
Could you check the windows event log please? See if there are any errors in there from around the time of the DBCC. Check the system and application logs.
April 2, 2008 at 1:43 am
Andre T (3/31/2008)
The big picture is a bit complicated. I certainly realize set based is better but this...
April 1, 2008 at 9:36 am
It specified on what columns the join is done.
Same as for a normal inner/outer join between two tables:
FROM Itable1 INNER JOIN Table2 On Table1.Col1 = Table2.Col2
Just in this case it's...
April 1, 2008 at 9:28 am
Any backup you've made since the problem started will have the damaged page in and hence is useless for recovering from this.
How long has this been going on? Why didn't...
March 31, 2008 at 2:35 pm
When was your last database backup? Is the database in full recovery mode, and , if so, do you have the transaction log backups since the last full backup.
How much...
March 31, 2008 at 1:57 pm
mostar5 (3/31/2008)
Anyone?
Sure.
Read what I wrote above. Help us with the table structures and sample data and someone will help you.
March 31, 2008 at 1:55 pm
Statistics time outputs in milliseconds. Microseconds would be 'us'. (iirc)
SQL Server Execution Times:
CPU time = 32 ms, elapsed time = 180 ms.
March 31, 2008 at 10:33 am
Hmmm....
What OS are you running? Please confirm that the drive is using the NTFS file system
March 31, 2008 at 10:29 am
I'll be 32 this year. I started the degree 2 years ago. Got another 2-3 years to go.
I would suggest you sit down and take a look at the reasons...
March 31, 2008 at 10:11 am
Anshu Wadhwa (3/31/2008)
There's no such encryption/decryption software on our server , no space issues either...What else can be the problem ..?
I take it you have a similar problem.
Can you post...
March 31, 2008 at 9:35 am
Ignacio A. Salom Rangel (3/30/2008)
GilaMonster (2/13/2008)
Can it be optimised to take less time? Can the indexes be tweaked so that it doesn't have to...
March 31, 2008 at 7:31 am
The date time problem's easy to fix. The variables need to be converted to string to concat them with the rest of the query. They also need to be wrapped...
March 31, 2008 at 7:28 am
Viewing 15 posts - 47,041 through 47,055 (of 49,571 total)