Viewing 15 posts - 49,021 through 49,035 (of 49,552 total)
the reason is i want to use the floating point value to be my unique key in the format of nvarchar
Why? If you want to use the current date as...
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
September 7, 2006 at 3:20 am
Firstly, don't use select *. It's lazy coding. Get into the habit of explicitly naming the columns in your query, and only returning the columns that you need.
Second, don't use...
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
August 31, 2006 at 2:12 am
EXECUTE Northwind.dbo.sp_who should have worked and printed Surprise.
Actually not, it has something to do with the name resolution, but any procedure that starts sp_ is first looked for in master,...
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
August 30, 2006 at 1:40 am
NULLIF takes 2 parameters, returns null if the two equal each other, otherwise it returns the first.
Hence NULLIF(fld, 0) returns NULL if fld is zero, otherwise it returns fld.
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
August 24, 2006 at 5:05 am
The dblog virtual function produces nicer output than DBCC Log. Specifically, since it's part of a query, it's easy to filter, group, etc
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
August 24, 2006 at 1:34 am
Datetimes are not stored in any format in a table. They're stored in a numeric format.
If you want to display a date in a specific format, then you'll need...
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
August 23, 2006 at 1:42 am
I don't know about those who are presenting, but I submitted an offer to speak at the conference, which was declined. I got a mail from PASS recently, thanking me...
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
August 22, 2006 at 1:59 am
Why don't you try it out? You can use the RAISERROR statement to force an error, or intentionally do an update that violates a constraint on the table.
Be very...
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
August 22, 2006 at 1:40 am
I'd also recomend 'The Guru's guide to SQL Server Architecture and Internals' by Ken Henderson
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
August 21, 2006 at 12:13 am
Oops, missed that. Thanks
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
August 17, 2006 at 11:44 pm
It's messy, inefficient and I'm sure several others will have better solutions, but this does what you want. The big problem is the comma-delimited values in the commission table
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
We stand on the bridge and no one may pass
August 17, 2006 at 12:17 am
or you can use the datalength function, which can be used on text fields
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
August 16, 2006 at 1:16 am
The SQL 2005 books online conain a lot of information for beginners. The sections on create procedure, insert statements, update statements and if - else statements will probably be of most...
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
August 11, 2006 at 5:35 am
Are you maybe trying to do this?
Select sum(cast(ISNULL(Hedonic_Value,0) as bigint)) as SumHedonic, sum(cast(sa_sqft as bigint)) as sa_sqft,
sa_census_tract, sa_census_block_group, count(*) as totalHomes, 'B' as HouseType
From ReplyAVM
Where isnull(sa_sqft, 0)...
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
August 11, 2006 at 5:31 am
I would agree on the job, but not on the cursor. From the sounds of things, the updates can be done set-based.
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
August 11, 2006 at 1:24 am
Viewing 15 posts - 49,021 through 49,035 (of 49,552 total)