Musakkhir Sayyed's questions

这是网址

www.abc.com/a/b/c/d/e/f/g/h/i

我想要这样的结果

www.abc.com/a/b/c/d/e/f/g/h/i
www.abc.com/a/b/c/d/e/f/g/h
www.abc.com/a/b/c/d/e/f/g
www.abc.com/a/b/c/d/e/f
www.abc.com/a/b/c/d/e
www.abc.com/a/b/c/d
www.abc.com/a/b/c
www.abc.com/a/b
www.abc.com/a
www.abc.com/

请看这段代码..

            declare @length as int
            declare @Totallength as int
            declare @min as int
            declare @strURL as varchar(max)
            set @strURL='www.abc.com/a/b/c/d/e/f/g/h/i'
            set @min=1
            set @length=(SELECT LEN(@strURL) - LEN(REPLACE(@strURL, '/', '')))
            set @Totallength=(select len(@strURL))
            if(@length>1)
            begin
            while(@min<=@length)
            begin
            --select @strURL=left(@strURL,charindex('/',@strURL)-1)
            SELECT  @strURL = SUBSTRING( @strURL, CHARINDEX('/', @strURL) + 1, @Totallength)
            print @strURL
            set @min=@min+1
            -- print @min
            end
            end

我想每 3 秒运行一次作业，但是在 SQL Server 2008 中，我们不能定义小于 10 秒的间隔。

该作业用于将访问者信息和分段信息插入/更新到由谷歌搜索跟踪的数据库中。

在 2 或 3 秒内最多插入大约 100 行。该作业在数据库中插入和更新表。有没有办法使用 sp 作业调度配置来安排它？

CREATE CLUSTERED COLUMNSTORE INDEX CCI_TempTable1 ON dbo.TempTable1 ON[PRIMARY]

触发此查询后，我发现了错误。

Msg 823, Level 24, State 2, Line 20
The operating system returned error 1(Incorrect function.) to SQL Server during a read at 
offset 0x0000018dc18000 in file 'D:\SQL2014\Data\TempDB.MDF'. Additional messages in the 
SQL Server error log and system event log may provide more detail. This is a severe 
system-level error condition that threatens database integrity and must be corrected 
immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be 
caused by many factors; for more information, see SQL Server Books Online.

我正在 SQL Server 2014 中创建聚集列存储索引。

我收到错误

“超时已过期。在操作完成之前超时时间已过或服务器没有响应。（Microsoft SQL Server）”。

我设置

EXEC sp_configure 'remote query timeout', 60000; reconfigure EXEC sp_configure

行数 = 304969603 数据空间 = 88,812.266 MB