Viewing 15 posts - 49,036 through 49,050 (of 49,571 total)
Yup, I've got a system just like it. GUID primary keys all with clustered indexes. However I've got just over a thousand tables.
How I've approached it is to change the...
September 12, 2006 at 5:24 am
It is possible for anybody to copy the mdf and ldf files of a database, copy it on another machine and have complete access over it
If users have access to the...
September 12, 2006 at 2:36 am
I'm mostly working less than 5 years ago.
5 years ago I was a senior developer at a small development company. It was the norm to get in before 8,...
September 8, 2006 at 2:58 am
The only problem I have with the page peel is that from time to time it throws a flash error and crashes IE. Some days it takes 3 or 4...
September 8, 2006 at 2:29 am
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...
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...
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,...
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.
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
*...
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...
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...
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...
August 22, 2006 at 1:40 am
I'd also recomend 'The Guru's guide to SQL Server Architecture and Internals' by Ken Henderson
August 21, 2006 at 12:13 am
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
August 17, 2006 at 12:17 am
Viewing 15 posts - 49,036 through 49,050 (of 49,571 total)