Viewing 15 posts - 47,806 through 47,820 (of 49,552 total)
Pleasure
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2008 at 1:48 am
Koji Matsumura (1/4/2008)[hr
Thank you Gail for the info.
I guess I was somehow confused with char VS varchar datatype.
Yeah. The varxxx datatypes have 2 bytes extra to store the data size
By...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2008 at 1:38 am
Koji Matsumura (1/4/2008)
In SQL Server , all representation of the NULL value are the same.Nullable datatypes are one byte larger than non-nullable ones.
Null and not null datatypes are the same...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2008 at 1:18 am
karthikeyan (1/4/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2008 at 1:07 am
What do you mean by trigger on an application? Triggers are placed on tables and views.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2008 at 12:40 am
Nisha (1/4/2008)
SELECT * FROM [MyDateTable]
WHERE StartDate >= CONVERT(DATETIME, '02/01/2007')
AND StartDate <= CONVERT(DATETIME, '01/04/2008')
This works fine, Jeff! Which is why I was saying, I used...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2008 at 12:37 am
So that changes made by one user don't affect another concurrent query (automatically done by SQL Server)
To ensure that a related set of data modifications are completed entirely or not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2008 at 12:36 am
Just trying to clarify some details of why the exec plan doesn't show the 4 million rows. If you'd prefer, I'll remove the posts
I agree that the exec plan doesn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2008 at 11:52 pm
mjafar (1/3/2008)
Yes sir,I m not using SQL server 2005.
The please post in the SQL 2000 forum so people don't waste their time and yours giving suggestions that don't work...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2008 at 11:38 pm
Not if you back it up. Tha backup log only truncated what it has backed up, so your log chain is safe.
It's if you truncate without backing up that you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2008 at 11:33 pm
Jeff Moden (1/3/2008)
No... my turn to disagree... execution plan showed 10,000 rows... there were only 25 in the result set...
There are only 25 in the final result set, as shown...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2008 at 11:29 pm
mjafar (1/3/2008)
Query u have given is not working...
In what way is it not working?
select name, recovery_model_desc, log_reuse_wait_desc from sys.databases where name = 'myDBName'
(replace mydbname with the real name of that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2008 at 11:20 pm
I think if you were going over the row size, the entire update/insert would fail.
If you go to query analyser and run
SELECT LEN(VarcharColumn) from TheTable
what do you get?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2008 at 11:16 pm
Exists doesn't care about the number of records. It's just checking to see if one does, or doesn't exist. It will return true as soon as it hits the first...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2008 at 11:13 pm
If there's a syntax roblem, the parser will pick it up. Other than that, you have to debug the code. Just like for C#, VB, Java and all the other...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 3, 2008 at 11:02 pm
Viewing 15 posts - 47,806 through 47,820 (of 49,552 total)