Viewing 15 topics - 270,031 through 270,045 (of 283,884 total)
Topics
Started by
Posts
Last post
I have a situation in which I find that I have the same (dimension) data repeated in three separate…
3 replies
Hi We are doing UPDATEs inside a cursor. We wanted Declare this cursor as INSENSIVE CURSOR to impro…
2 replies
Running SQL 7.0 sp3a (soon to be SQL 8.0) We want to move the tempdb log file to a different logica…
2 replies
Please help me. I create an update trigger to prevent users from updating my data if the date of t…
2 replies
I'm trying to use the debugger but get 'Cannot load the DLL mssdi98.dll, or one of the DLLs it refe…
1 replies
Is there such a thing 'SQL Server 2003'? What is the next version of SQL Server after SQL Server 20…
4 replies
set ansi_nulls off go create table t1( f1 varchar(10) null, f2 varchar(10) null) go insert into t1 …
2 replies
Here is an output from a DBCC ShowContig for one of my database servers before and after defragment…
3 replies
What is the best way of getting the first and last record of a group? I will use Northwind as an ex…
5 replies
Hi, I have a cube with a date dimension of Year – Qty – Month – Date And I am access the cube via …
1 replies
Hi, We are in SQL Server 2000 and we just changed our databases to full recovery model last mon…
1 replies
When you use a "Delete" command to delete ALL the records in a table the sp_spaceused still reports…
10 replies
Hi, Is there a standard for setting up Testing/QC Environments?. We want to be able to set up Test/…
2 replies
Hi, I need to convert the display representation of a varbinary value as varchar. e.g., the result…
2 replies
I want to update a column (colA) in my database to include part of another column (colB) The update…
2 replies
Viewing 15 topics - 270,031 through 270,045 (of 283,884 total)