Viewing 15 posts - 106 through 120 (of 1,838 total)
Hi,
I am facing an issue with exporting data from flat file to SQL using SSIS. The flat file has the following data (also attached as Flat_file):
This delimited file structure...
February 24, 2020 at 9:00 pm
Note that the "Text" column of sys.comments is only NVARCHAR(4000), so if you have a longer stored procedure that view would not see the entire definition. For the complete definition,...
February 24, 2020 at 8:46 pm
Do you test each full backup every day or do you sample every other day or once a week? With one test server, I don't think we could make it...
February 24, 2020 at 8:13 pm
"SQL Server Management Studio" is not a server, that is the SQL Server client tool, the equivalent of MySQL Workbench.
Even if you do have a SQL Server instance installed, MySQL...
February 24, 2020 at 5:40 pm
So is it SQL Server you are connecting to or MySQL? This is a SQL Server forum, and MySQL Workbench will not be able to connect to Microsoft SQL Server.
February 20, 2020 at 9:55 pm
Doing a quick search found this other thread, with a script from a highly respected person:
https://www.sqlservercentral.com/forums/topic/script-out-database-mail-settings
February 20, 2020 at 4:56 pm
If you were trying to see all the way back to the 16th there is a possibility, if this is a query that isn't called very often, that it is...
February 20, 2020 at 4:01 pm
...Sometimes what may make sense when it comes to normalization doesn't make sense in the database itself.
I can't agree more. While it is possible to have an additional lookup...
February 18, 2020 at 10:06 pm
using that create table script and insert into statement, trying to run this query and getting no results. Any thoughts as to why?
I think the reason people want to...
February 18, 2020 at 9:37 pm
Since you already know that the server is dedicated to SQL and that CPU utilization is high, I'd look at the plan cache to see what queries are the high...
February 18, 2020 at 8:44 pm
Not to be rude, but I'd have to agree with Trowley here. While during a scan you may see individual S locks page locks come and go quickly on the...
February 18, 2020 at 6:06 pm
I also believe it's not wise to break out the postal code (not every country calls it a zip code) from the rest of the address. City and postal code...
February 18, 2020 at 5:09 pm
The easiest way to see how many duplicates exist for each, is to just use GROUP BY and HAVING clauses. What have you tried?
February 17, 2020 at 9:05 pm
I think you need a few functions for this solution. SCDecade almost had it right, to determine the @StartDate, try:
SET @StartDate = SELECT DATEFROMPARTS(@year, ((@QuarterID - 1)...
February 17, 2020 at 7:43 pm
Actually I think the existing code looks like it could end up duplicating rows from the #temp table into the PartsData table. If there is a spreadsheet that has both...
February 13, 2020 at 8:19 pm
Viewing 15 posts - 106 through 120 (of 1,838 total)