Viewing 15 posts - 28,606 through 28,620 (of 49,552 total)
deepikamm (1/6/2011)
@gila: i hav seen queries like" if exists ( select 'x' from tablename)" actaully i meant this query only.
There's a massive difference between SELECT 'x' from table and SELECT...
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 6, 2011 at 4:14 am
raj.lath-932078 (1/6/2011)
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 6, 2011 at 3:22 am
deepikamm (1/6/2011)
why do people make use of "select x" instead of "select columnname"?
Errr, they don't. Select x is only possible if there's a column called x, otherwise it will throw...
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 6, 2011 at 3:20 am
It returns the column X for all rows in table tablename
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 6, 2011 at 2:51 am
No one's annoyed.
The simple truth is most of those question are easily researchable, and the ability to research is a very important skill for a DBA.
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 6, 2011 at 2:07 am
The replacement for text is varchar(max)
The replacement for ntext is nvarchar(max)
The replacement for image is varbinary(max)
As for general advice, what I said in the first post. In general use the...
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 6, 2011 at 2:06 am
Craig Farrell (1/6/2011)
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 6, 2011 at 1:49 am
Not offhand, but in general use the most appropriate datatype and keep it as small as possible, but not too small.
Be aware that ntext, text and image are deprecated and...
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 6, 2011 at 1:36 am
vinodh247 (1/5/2011)
9) What are the frequent database issues you face in your present job & how you troublshoot it?10)What is the sev3/sev4 issue you have faced till now?
We can't answer...
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 6, 2011 at 12:21 am
Did you try a google search?
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 6, 2011 at 12:20 am
create table ##tmp (TableName varchar(40),DefinedRowSize int)
exec sp_msforeachtable 'INSERT INTO ##TMP Select ''?'' As TableName, SUM(C.Length) as Length from dbo.SysColumns C where C.id = object_id(''?'') '
select * from ##tmp order 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 5, 2011 at 11:55 pm
No more replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1043259-392-1.aspx
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 5, 2011 at 3:02 pm
You lot are nuts.
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 5, 2011 at 3:01 pm
No and no intention to ever have. Got enough accounts in enough places. Don't need or want another one.
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 5, 2011 at 10:52 am
Koen (da-zero) (1/5/2011)
I have never understood the fuzz about "division by zero". It is possible, it just doesn't return a normal number.
However if you allow it, it's trivial to...
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 5, 2011 at 10:44 am
Viewing 15 posts - 28,606 through 28,620 (of 49,552 total)