Viewing 15 posts - 256 through 270 (of 455 total)
1. Did you check SQL Server log file? Every time Cachestore is flushed it records it to SQL Server Log along the reason why it was flushed.
2. From your post...
May 1, 2014 at 12:56 pm
...creating a secondary filegroup and then dropping and recreating all indexes in the database which is going to take ages (we have a lot of tables and indexes)...
adding the...
April 28, 2014 at 3:32 pm
DBE is usually something in between (or a combo of) DBA and DBD (which could be DB Developer or Designer).
I never heard about Data Scientist, but I knew some Data...
April 17, 2014 at 9:11 am
You have problems with memory, not disk space. Check min, max server memory.
April 15, 2014 at 9:17 am
Thanks Jason. This works well, my bandings are evenly distributed. This is exactly what I expected.
April 14, 2014 at 9:35 am
SET NOCOUNT on
IF OBJECT_ID('table1','u')IS NOT NULL
DROP TABLE table1
go
create table table1
(Subject varchar(10),
Mark int
)
go
insert into table1
values
('Matchs',90),
('Physics',85),
('English',50)
go
declare
@Subject varchar(1000) = '',
@mark-3 INT = 0
select
@Subject = @Subject + ',' + Subject,
@mark-3...
April 10, 2014 at 8:47 am
If your database is small, your hourly snapshot will work fine. But if it's large, you may end up with creating snapshot for all your one-hour time frame. That's because...
April 3, 2014 at 2:02 pm
The same problem I had at my previous job. I solved it by copying .bak file to external hard-drive, brought it to my domain, inserted to a server at my...
April 3, 2014 at 1:46 pm
Sean Lange (4/3/2014)
SQL Guy 1 (4/3/2014)
How many columns do you have to alter?
Totally 9 columns:
7 : Nvarchar --> varchar
2 : text --> varchar
Ouch. Not sure what your table looks...
April 3, 2014 at 1:27 pm
Are you sure that the query is still running ?
April 3, 2014 at 1:22 pm
How many columns do you have to alter?
Totally 9 columns:
7 : Nvarchar --> varchar
2 : text --> varchar
April 3, 2014 at 1:07 pm
1. Do you know SPID #? Are you running it from SSMS? You can get SPID # from the status panel in the botom.
2. What sys.sysprocesses says about this SPID...
April 3, 2014 at 12:42 pm
Number of databases does not matter. At my last place I had just one database with size > 2.5 TB. At my present place I have about 20-30 databases ,...
April 3, 2014 at 12:37 pm
Sean Lange (4/3/2014)
The proper syntax is quite simple.
ALTER TABLE t1
ALTER COLUMN c1 INT;
ALTER TABLE t1
ALTER COLUMN c2 varchar(10);
I am just doing this way - separate ALTER statements, but my table...
April 3, 2014 at 12:28 pm
Grant Fritchey (4/2/2014)
There's a lot to it. I wrote a book on the topic (look in the links below). But, to get you started, I'd recommend this blog post.[/url]
excerpt from...
April 2, 2014 at 9:54 am
Viewing 15 posts - 256 through 270 (of 455 total)