Viewing 15 topics - 33,211 through 33,225 (of 284,230 total)
Topics
Started by
Posts
Last post
Hello, I am receiving LCK_M_IX locks on truncating the table (140K) records . It was fi…
1 replies
Hi Friends, I want to retrive each nth row from a table in sql server 2000. Example: if i …
8 replies
So, i'm currently using the below to change a VARCHAR field over to a INT and remove the first char…
7 replies
Hi Everybody,I have a question concerning Backup.I have a partition which is growing (D:\) more and…
12 replies
Ok so my understanding is that all Azure SQL databases are full recovery and cannot be changed.&nbs…
3 replies
Hello Everyone, I have a raw table with Billions of records. I have a look up table with around 100…
2 replies
I've always wondered why you can't use datediff with two dates that are in int format. When I run s…
7 replies
DECLARE @Temp Table (ID int, Make varchar(2), Model varchar(2), ModelYear int, FuelType varchar(15)…
10 replies
Have SQL2014 Express installed trying to link server to a SQL 2008 Std. Both on 64-bit machines (S…
2 replies
Hi, I'm using a time series table with a SMALLDATETIME field.The table stores sensors' data every 1…
5 replies
We need to change padding (it is reflected in is_ansi_padding from sys.columns) for a column in exi…
1 replies
Comments posted to this topic are about the item Batch Preceding ----------------------------------…
13 replies
I'd like to get a SQL Server Transaction Log Analyser. I'm mainly interested in being able to work …
7 replies
HI, I think I have bad data getting into one of my tables. I have searched and found some scrub/ch…
2 replies
Hello there, I have the following derived table extract below :- RowId Date Value NextValu…
10 replies
Viewing 15 topics - 33,211 through 33,225 (of 284,230 total)