Viewing 15 posts - 1,666 through 1,680 (of 15,381 total)
amy26 (3/21/2016)
How big is nvarchar(max)? I know it says 2 to the 31st power or something... but I'm a dumb dumb and I...
March 21, 2016 at 8:16 am
As a side note you seem to be littering your database with NOLOCK hints. This is generally not a good idea, especially in things like views. That hint is far...
March 21, 2016 at 7:58 am
Goldie Lesser (3/18/2016)
Ed Wagner (3/17/2016)
If it doesn't have a sequence number, I wont be using it. 'Nuff said.
I use Jeff's function all the time, and I can't even think...
March 18, 2016 at 3:06 pm
I agree with Jeff on this one. Trying to do this in sql is dealing with the symptom instead of the problem. In this case the problem is a poorly...
March 18, 2016 at 10:11 am
andrewbowles949 (3/16/2016)
Sorry my mistake its a time(7) field there is no real reason that its split other than perhaps my inexperience! I will check out the links ..... Andrew
What...
March 16, 2016 at 5:51 pm
andrewbowles949 (3/16/2016)
March 16, 2016 at 4:23 pm
dwilliscp (3/16/2016)
March 16, 2016 at 11:55 am
LOL I suppose dropping the table is the easiest way to solve the issue. Glad you were able to find out you could remove it. 😛
March 16, 2016 at 11:51 am
SQLAssAS (3/16/2016)
Hello,Just a shrink command..
DBCC SHRINKFILE (N'DATABASE' , 100621)
GO
I just ran a checkDB on the database and no errors popped up so corruption shouldnt be an issue
Hehe just a shrink...
March 16, 2016 at 8:40 am
Or use a table valued parameter or even a string splitter.
--EDIT--
It seems a couple new posts happened while I was posting. I got sidetracked and went for my coffee. :w00t:
March 16, 2016 at 8:18 am
SQLAssAS (3/16/2016)
I am trying to relase space from one of our databases and the following pops...
March 16, 2016 at 8:17 am
Steve Jones - SSC Editor (3/15/2016)
I'm sad today
Doh!!! That sucks. At least it looks reasonably minor so nobody got hurt!!!
March 15, 2016 at 11:02 am
ChrisM@Work (3/15/2016)
March 15, 2016 at 8:17 am
jasona.work (3/15/2016)
Will Jeff Moden be able to stop work on his string splitter??
Will Batman be able to get rid of the bomb before it blows up?!?!
Tune in...
March 15, 2016 at 7:00 am
You should read more about tally tables here. http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D
I keep a view in my system with a tally table that looks like this.
create View [dbo].[cteTally] as
WITH
E1(N) AS (select 1 from...
March 14, 2016 at 10:38 am
Viewing 15 posts - 1,666 through 1,680 (of 15,381 total)