Topics
Started by
Posts
Last post
in windows services -SQL server (mssqlserver) service properties recovery tab what action to add
2 replies
I have an ssis package that runs as a proxy (sql login) ==coldfusionuser This account is used in co…
3 replies
Rounding percentages and summing them up will not give correct results all the time due to the roun…
6 replies
Hi, I need help on below issue: I need to pick the dates for last 8 Fridays. The input will always …
21 replies
We are trouble-shooting a nightly job we are having issues with. The code seems like a fairly strai…
3 replies
I know that the use of NOLOCK can be a very bad thing in most cases, but I am curious about the how…
8 replies
I am getting different results for two queries about a table column. when I run the following query…
3 replies
Hi All, I have installed SQL2008 R2 on Win 2k8 Enterprise Edi. The server is not on domain, its on …
11 replies
Ive just run a very large delete statement in a stored procedure that deletes data from around 15 t…
10 replies
We are starting to get quite a few DB locks. I believe the Lock parm for our DB is RC. If user '1' …
5 replies
Hello, I am using below store procedure to fetch the record on live, But it is taking too long tim…
10 replies
Hi! I'm looking for some real life auditing examples. As a dba I need my back covered:-) Auditing i…
1 replies
Hi experts, I have 2 tables in my DB. 1. BookSales(135m rows) 2. AdminFees(13m rows) Both having …
2 replies
In sybase we have identy_gap command to limit the identiy burn outs. What is equivalent comand for …
7 replies
I have an application that assembles a SQL query and sends it to the SQL Server engine for executio…
2 replies
Viewing 15 topics - 17,146 through 17,160 (of 30,188 total)
You must be logged in to create new topics.