Viewing 15 posts - 241 through 255 (of 13,463 total)
there is no need to install office on a server.
SSIS will use the ACE drivers to create excel documents, so there is no need to install Office , and...
February 18, 2019 at 6:52 am
something like this should work:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
GO
IF OBJECT_ID('tempdb.[dbo].[#Results]') IS NOT NULL
DROP TABLE [dbo].[#Results]
GO
CREATE TABLE [dbo].[#Results]...
February 12, 2019 at 8:38 am
restore the table from a backup. you have permanently converted the previous data to bad data/question marks instead of retaining the original values. February 12, 2019 at 7:04 am
Turkish characters sets use
it changes, base don the version of SQL you connect to.
a connection to SQL2008R2, for example, does not have the columns [NetAddress],[ExecutionCount],RequestID], but a connection to SQL 2016 does...
February 12, 2019 at 6:29 am
parameter sniffing gone wrong can often(almost always?) be related to statistics being out of date.
look at the tables being used in the procedure; it only takes a small percentage...
February 11, 2019 at 1:46 pm
from inside the procedure, the commands run in the order you created them in, and there is no way for the third to execute before the previous commands complete.
February 10, 2019 at 6:39 am
you want to use Datetime for all values
here i am stripping out time to get the first day of the current week/Monday, and adding either one or two...
February 4, 2019 at 11:14 am
one of the know requirements when you upgrade is to update statistics for all tables, as the optimizer is different.
did you rebuild your indexes/update statistics yet, after upgrading to...
February 3, 2019 at 8:24 am
you want to store it with the line feeds in place already.
INSERT INTO YourTable ( ID, NickName,Category,Phrase)
SELECT 1,'excitedBirthday','Birthday',
'I bet you''re so excited
Excited...
February 3, 2019 at 6:34 am
its also possible with OpenXML and a script task, but the learning curve to learn to get that right is pretty steep.
once you have it though, you can decide...
February 3, 2019 at 5:36 am
stick with the SSIS wizard and avoid a linked server.
the SELECT INTO FROM linkedServer... will be a massive logging operation, and you might run out of disk space due...
February 3, 2019 at 5:29 am
yes, i store queries like that in a table, and execute them all the time.
there are two simple ways, note i had to escape the single quotes within the...
February 3, 2019 at 5:24 am
grid view always compresses the data to a visible sinlge row, and makes CrLf appear as spaces.
what you want is to make sure a copy/paste from a grid still...
February 2, 2019 at 5:27 pm
here is an example, splitting the list of all your tables in your current database, into five columns;
i think you can adapt that to only have four columns,...
February 2, 2019 at 11:33 am
the issues is object owner chaining. cross schema or cross database queries break the object chaining inheritance, and require select permissions to teh underlying tables.
you don't want that, you...
January 31, 2019 at 1:06 pm
Viewing 15 posts - 241 through 255 (of 13,463 total)