SETUSER can be used by members of the sysadmin fixed server role to adopt the identity of another user in order to test the permissions of the other user. Only use SETUSER with SQL Server users. It is not supported with Windows users. When SETUSER has been used to assume the identity of another user, […]
2003-05-13
I am loading a large file that I select records in a veiw then I match with other Views - sometimes linking up to 20 Views - Can anyone recomend a better way ?
2003-05-09
Ok, had to use a cursor, try this. create table #tblResponses (Resp int, ProdName char(1), Value varchar(3)) insert into #tblResponses values (1, 'A', 'Yes') insert into #tblResponses values (1, 'B', 'No') insert into #tblResponses values (1, 'C', 'Yes') insert into #tblResponses values (1, 'D', 'Yes') insert into #tblResponses values (2, 'A', 'Yes') insert into #tblResponses […]
2003-05-09
1 reads
Also, have you checked the load on the server to see how bad it may be. If you have a bottlenecked system you may see timeouts on any complicate query and then if gets worse all queries will timeout. Look at memroy, swap file, Hard Drive IO and CPU utilization.
2003-05-09
1 reads
Steve...server agent will not start up. See message in initial post when trying to start up. I think gfahrlander is on the right track here.
2003-05-07
1 reads
OK, here's my idea. I am still using a cursor to define the product combos. However, once defined, the combo list only needs to be changed if products are added or dropped. First, assume the products are in #tmp_prod, and that the prod column will identify them in the response table. ---------- create table #prod_combo […]
2003-05-07
1 reads
Read this KB articles. http://support.microsoft.com/default.aspx?scid=kb;en-us;316989 http://support.microsoft.com/default.aspx?scid=kb;en-us;815154 Edited by - Allen_Cui on 05/07/2003 08:05:49 AM
2003-05-07
quote: Since you are ignoring NULLS then this I think is what you are looking for is something like this. SELECT (CASE WHEN ProdA = 1 THEN 'A' ELSE '' END) + (CASE WHEN ProdB = 1 THEN 'B' ELSE '' END) + (CASE WHEN ProdC = 1 THEN 'C' ELSE '' END) AS Combination, […]
2003-05-07
1) If this was an OEM copy then technically NO as it is only supposed to go with the original equipment (there are a lot of ins and outs to this that can bite you in a production environment). 2) Yes, does require activation with Microsoft. But if you mean does XP make it's presence […]
2002-04-17
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers