Topics
Started by
Posts
Last post
Hello, I did a check in my table and I found these duplicates: Key Month Usage 45 Sept …
4 replies
I've created the following trigger to track logons: Use master Go Create database AuditDB Go USE […
12 replies
Dear Experts, I understand that without test data and actual DDL it is hard to get anyone to help w…
1 replies
I'm using the below query to find when was my statistics last updated. But I wanted to know how sta…
6 replies
We want to have 'test,' 'staging,' and 'production' SQL Server Environments. Our production server…
1 replies
Hello all, I "inherited" the following code as part of a query for a report: -- January if @MonthUn…
6 replies
I was trying to shrink the log on a database in simple recovery. It shrunk by about 10Gb, and then …
1 replies
Hi Professionals I have a varchar column in my table with pricing information in it that has up to …
5 replies
Installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS. now I am unable to connect …
2 replies
Hi guys, I want to add a SQLAgent check into my hourly job, alerting if it's down as long as its no…
1 replies
Hi, Today I’m using a connection to an excel file using PowerPivot and I’m using a sql query to ret…
1 replies
Table1 : id, Name Table2: id, name1,name2,name3,name4,name5 MERGE Table1 t1 USING table2 t2 ON t1.i…
8 replies
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'…
1 replies
Hi, Within a SQL job I would like to to get the information from the Data sources tab, so for each …
6 replies
Hi All, In my SQL Server 2008R2; if i run SP_WHO2 i see lots of SPID(Awaiting Command) with sleepin…
1 replies
Viewing 15 topics - 9,451 through 9,465 (of 30,225 total)
You must be logged in to create new topics.