Topics
Started by
Posts
Last post
Hello, I have the below query working properly by but very slow, the sub-query is the cause of slow…
3 replies
Hi all, I have an issue with one job in SSMS which uses some SSIS Package. I'm receiving the error …
1 replies
Hey Gurus, I have a query that performs differently depending upon the user executing it. This was…
31 replies
Hello my table CREATE TABLE #DETAIL ( IDR INT, ID INT, AMOUNT FLOAT, BALANC…
7 replies
Hello guys, I want to discuss about your experience what is better. for example. I have procedure …
22 replies
I am writing a stored procedure with optional variables, but am not sure the best way to represent …
5 replies
I am having trouble with a CASE statement like this. The All Cars doesn't work. SELECT CASE WHEN CA…
7 replies
Do you guys recommend upgrading SQL Server 2008 R2 to 2017 by just running the disc and uprading? O…
6 replies
What property value do I need to set so that the header row I created displays on subsequent pages?
17 replies
Hi All, I need to insert sp_spaceused output of DATABASE into temp table. How can I do this? Pls su…
13 replies
SELECT sqltext.TEXT FROM sys.dm_exec_query_stats AS CP CROSS APPLY sys.dm_exec_sql_text(sql_handle)…
3 replies
When I double click on a .sql file, it starts up SSMS and loads my file. When I click on a second …
16 replies
I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of th…
47 replies
I have the following trigger: Create trigger [dbo].[new_Location] on [dbo].[TBL_LOCATIONS] for inse…
9 replies
When I copy/paste grid results from SQL Server Management Studio --> an Excel file, the WORD "NU…
48 replies
By: kaj
Viewing 15 topics - 1 through 15 (of 30,210 total)
You must be logged in to create new topics.