Topics
Started by
Posts
Last post
Hello Everyone, Currently I am having an issue, I did my SQL Script and it takes a decent amount of…
5 replies
I want to know how order of joins executed in sql server. Suppose i have used 3 tables in join. tab…
5 replies
I have a table that my company uses for logging. One of the columns is declared as: event (sysname(…
2 replies
hello, Is there a way in whihc we can combine the out of sp_who2 with sysprocesses table in sql 200…
3 replies
Friends, One of my colleagues sent me the following code: DECLARE @TMP TABLE (RecID INT, Number IN…
5 replies
HI I need to optimize below query ... currently I do not have DDL and index info with me..find belo…
6 replies
Hi, Is there any way to force the recompilation of an already running query based on plan handle? T…
1 replies
To check if an extended event session with a name exists I use the following statement: SELECT 1 FR…
1 replies
Hi, I have .dat file with following format data. 1,2,3, 4,5,6, 7,8,9, i want load this format file …
5 replies
I have a table in the below format. S.no Travel Expense Stay Expense Mis Expens Date …
2 replies
PLEASE HELP ME WHO EVER CAN WRITE MORE EFFICIENT T-SQL THAT ANSWERS THE QUESTION. THIS IS WHEN WE D…
8 replies
Hi, All. Could you, please, help me with sql query ? For example, if I have a table1 like the follo…
3 replies
If I want to filter out where companyID has two alpha letters, what is the sysntax: Currently the c…
2 replies
The following two T-SQL statements return exactly the same row set whatever data is: [font="Courier…
13 replies
Hi All, I have some update and insert queries to update GEO location data, which when I execute on …
3 replies
Viewing 15 topics - 4,351 through 4,365 (of 10,647 total)
You must be logged in to create new topics.