Topics
Started by
Posts
Last post
Hi all, I am tuning some expensive queries , 1 of them is : Select * from Table A Where Date >= …
5 replies
I have a below query which have a date filter like "EST_PICK_DATE between '2015-02-01' and '2015-06…
1 replies
Hello Folks, Somewhere i read..that in SQL Server...usage of Built-in Functions on Columns, makes q…
4 replies
For finding size values of temp database: select * from sys.master_files - size column value here i…
1 replies
Dear Experts, How to combile multiple rows to single rows for the below sql query. SELECT dbo.…
2 replies
Hi SQL gurus, I have a table called 'AssetPlacements' that shows the dates when certain objects (A…
7 replies
hello: working on sqlserver 2008 R2 CREATE TABLE OrderRanking ( OrderID INT IDENTITY(1,1) NOT…
2 replies
While trying to solve a SQL challenge I found myself trying to understand what is happening when yo…
13 replies
DECLARE @DBEngineLogin VARCHAR(100) DECLARE @AgentLogin VARCHAR(100) EXE…
3 replies
I have a table sorted by vendor, then item, then Status date with a QC Pass date and Fail date. I n…
7 replies
Hi All, In one of our Table Functions, OPENROWSET is being used and as per my understanding, we can…
9 replies
Hi Folks Setting: 2 node 4 Instance Cluster All SQL Instance on 10.50.4000 Node 1: SQL1 Node 2: S…
3 replies
It has come to my attention that some non-IT users in my organization have SSMS installed on their …
1 replies
Good day, I need some with selecting the number of days, in a month, between a date range. For exam…
10 replies
Hi All, I am working with one of the production database around 200 GB. This database has above 350…
2 replies
Viewing 15 topics - 4,051 through 4,065 (of 30,225 total)
You must be logged in to create new topics.