Topics
Started by
Posts
Last post
Hello, I need to auto increment an alphanumeric field in a table. The process is as follows: 1. Fir…
11 replies
Hello, Attached text file contains a script I started putting together this evening. The basic prem…
1 replies
Experts, I have an sql query am using which takes over 10minutes to draw data. it is divided into…
21 replies
CREATE TABLE GROUPS( CONTRACT VARCHAR(5), PACKAGE VARCHAR(3), GROUPNBR VARCHAR(5), SUBGROUP VARCHAR…
2 replies
This is the file name: aSNAP_Data_20140929_P-2014-09-29_07.01.34.dat I need to give this name to th…
4 replies
Here is the data I am working with: CREATE TABLE CUSTOMERS( CUSTOMER VARCHAR(11), CONTRACT VARCHAR(…
1 replies
Hi, I need help with an update query given below, CREATE TABLE #Tracking ( ID INT IDENTITY(1,1),COr…
2 replies
Hi There, I'm dealing with huge database. So I thought to go with the data compression because it w…
3 replies
Hi all, I'm using SQL Server 2012 and I need to run a query against my database that will output th…
15 replies
Hi all, I have a stored procedure and in that I will be calling a stored procedure. Now, based on t…
3 replies
We have a hierarchical table of some 2-3k of rows that grows slowly at only 3-5 rows a month, and i…
5 replies
Hi There, Index is double edged sword. So we have to be very careful while creating index. Pls sugg…
1 replies
I have a query i have been optimizing. Now runs in about 15 minutes but was wondering if there is a…
11 replies
Hi, Is it possible to get all information about modification of sql objects, For eg. I have stored …
10 replies
Hi, I need to have a process extract some data, export it to CSV and then send it as a plain (non-M…
8 replies
Viewing 15 topics - 3,781 through 3,795 (of 4,984 total)
You must be logged in to create new topics.