Topics
Started by
Posts
Last post
I need a way how to handle described situation bellow, which will work very fast for lot of rows. …
7 replies
Hi guys, does any one have a good idea(or code) to reduce the size of live data so it can be used f…
6 replies
CREATE TABLE [dbo].[MyTable]( [CampusID] [int] NOT NULL, [Campus] [varchar](20) NOT NULL, [TermI…
7 replies
Hi, I am by no means an expert on SB, but I thought I had my head around it until this happened... …
1 replies
Is there any way to get the Columns Used in where condition in a procedure using SQL?
1 replies
I am going to try and simplify this because I think I am thinking to hard for the problem at hand..…
3 replies
Hello Everyone I am reviewing code in a SQL database that was coded by a BA and a Old oracle develo…
4 replies
I need to send data from a MS SQL Server table to a PostgreSQL table on INSERT/UPDATE. I was thinki…
8 replies
I have first column as char and 2nd column as date please see if I am doing right or wrong I am get…
9 replies
Hi, Do we have any specific mechanism or tools that can predict the dead lock that's will be going…
11 replies
Hi, Let's say I have a query like: SELECT * FROM Table1 T1 INNER JOIN Table2 T2 ON T1.ID = T2.ID IN…
3 replies
i am experimenting with Partitioned Views again. CREATE TABLE test_1 (TestID INTEGER PRIMARY KEY …
3 replies
Create Table #Temp (ID int not null primary Key, Name varchar(25) not null, DOB datetime not null, …
5 replies
Hello. I created a login trigger to insert data for each login in a table, and it works for all log…
2 replies
Hi All , We are runing select statement which read the data , which spawns many threads all into CX…
6 replies
Viewing 15 topics - 4,156 through 4,170 (of 4,984 total)
You must be logged in to create new topics.