Viewing 15 posts - 1,621 through 1,635 (of 1,838 total)
Personally, I've always tried to avoid situations where there is alot of virtual memory page swaps for servers where SQL Server was running on them. This is really a...
December 15, 2008 at 8:07 am
To describe how I develop or debug SQL as a process, I'd have to say what I do is simmilar to test driven development, but not nearly as formal.
I start...
December 12, 2008 at 9:46 am
I've always been a visual thinker so I can appreciate Phil talking about seeing the joins or smelling code trouble. To me, I see the data flow through each...
December 12, 2008 at 7:25 am
What we do in our systems, for datetimes that our clients can see in the user interface or reports, we use their local time (keeping track of what time zone...
December 11, 2008 at 9:07 am
:w00t: D'oh! Copy and paste error, it should have been:
SET @SQLString = N'SET @ThisBugCount = (SELECT COUNT(*) FROM ' + ...
since @ThisBugCount is the variable I setup as the...
December 11, 2008 at 8:45 am
I've made a couple of modifications:
SET ANSI_NULLS ON
SET NOCOUNT ON
DROP TABLE BUGCOUNT
CREATE TABLE BUGCOUNT (DBName varchar(40), BUG_COUNT int)
-- create cursor to hold a list of all database names
DECLARE @BUGCOUNT as...
December 10, 2008 at 3:16 pm
You can creeate the ODBC DSN in the Administrative Tools of Windows XP / Data Sources. Administrative Tools is available in the Start menu directly or through the control...
December 10, 2008 at 2:53 pm
Jeff Moden (12/9/2008)
If you really want to lock things down, use BULK INSERT and format files (if you need them).
It really depends on the format of the CSV file. ...
December 10, 2008 at 9:43 am
I can see a couple of options offhand, not sure which is best depending on the setup of the client machines:
1) If the database name within SQL Server is...
December 10, 2008 at 9:18 am
It sounds like you are facing multiple challenges here. The "low on system resources" message is probably referring to memory on the server. What all is running on...
December 10, 2008 at 8:57 am
venki (12/10/2008)
Can any one check this and tell me why I am not able to access the system table sys.dm_db_partition_stats ?
Is the DBA unwilling to grant the VIEW DATABASE STATE...
December 10, 2008 at 8:47 am
Books online is your friend. The page below has the information_schema views:
http://msdn.microsoft.com/en-us/library/ms186778(SQL.90).aspx
December 10, 2008 at 8:42 am
Is this query part of a stored procedure? If so, the easiest way to work with this might be to determine a couple of things first, such as getting...
December 9, 2008 at 12:44 pm
I believe it's getting confused in the correlated subquery. Aliasing the tablenames seems to work for me:
insert into @tbl1 select col1 from @tbl2 t2 where not exists (select 1...
December 9, 2008 at 8:48 am
Steve Jones - Editor (12/9/2008)
...getutcdate() will help, but clients and code then need to convert this back if clients need to see local time.
in 2005 is there a way for...
December 9, 2008 at 8:40 am
Viewing 15 posts - 1,621 through 1,635 (of 1,838 total)