Reporting Services (SSRS)

MCDBA EXAMS

• by nmsunils

• Other

• Topic

Can any one tell Which are the exams to take for MCDBA and books prefered for the same

2001-12-18

4 reads

Finding duplicate row values

• by mmcardle

• MSDN Communities

• Topic

I've been struggling with this for a while. I imagine the answer requires a few temporary tables, but does anyone else have a more elegant solution? I have a table with four fields in it. The fourth field contains duplicate values. I want to insert into a new table just the values in the fourth […]

2001-12-14

1 reads

SQL and RAM requirements

• by rob_naude

• Database Journal

• Topic

Hi I know there are no hard and fast rules to how memory a server should have - but how does one determine the RAM requirements for SQL when it uses all avail. memory less 5 MB? The machine is dual 550MHZ 1GB RAM and approx 200-250 connections simultaneously. Occasionaly it is extremely slow, then […]

2001-12-14

4 reads

Help on "not in!"

• by mrhutch

• Other

• Topic

I use statements like the one below where I select all the possible records I may require and then filter by using "not in" and going off looking at another table. The statement below works fine and returns over 400 rows but if I change the '2001-05-31' for '2001-05-30' it returns no rows. There is […]

2001-12-05

XML

• by Alik

• MSDN Communities

• Topic

Can I use XML in SQL Server 7.0? And what do I need for that? I found example on the Internet and they tell you that this code should work for SQL Server 7.0 for Pub database, but it doesn't: SELECT store.stor_id as Id, stor_name as Name, sale.ord_num as OrderNo, sale.qty as Qty FROM stores […]

2001-12-03

1 reads

The undocumented nature of sp_readerrorlog in SQL Server 2000

• by Brian Knight

• Database Journal

• Topic

Comments posted to this topic are about the content posted at http://vyaskn.tripod.com/sp_readerrorlog_undocumented.htm

2001-12-01

7 reads

Missing stored procedure 'sp_MSupd_TblProducts'

• by Paul Ibison

• Other

• Topic

Am setting up transactional replication and the Log Reader Agent works fine, but I get the message "Could not find stored procedure 'sp_MSupd_TblProducts'" when I run the distribution agent. This stored procedure doesn't exist on the subscriber (Push Subscription is set up), so I must have missed out an initialisation step - any ideas? Paul […]

2001-11-30

5 reads

database design

• by sanmathy

• DevX

• Topic

I am planning to do a online question system and i am having some problems with my database design. I want to achieve this. Movie questions Q1. who directed the movie "braveheart" Q2. was titanic directed by steven spielberg True False Music questions Q1. who sung "take my breath away" Q2. robbie william was born […]

2001-11-28

Introduction to ADO Part 4 - Combining It All

• by Andy Warren

• Other

• Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/awarren/introductiontoadopart4combiningitall.asp

2001-11-25

11 reads

Getting Identity of an Updated Row

• by bigdave

• MSDN Communities

• Topic

I want to return the identity for a row that was updated using an update statement. The update statement is as follows: UPDATE Answers SET InUse = @SessionID FROM (Select Top 1 AnswerID from Answers_Eligible) . . . I need the asnwerid for the updated record. @@Identity is only useful for inserts. Any suggestions appreciated. […]

2001-11-20