300 reputation
29
bio website
location
age
visits member for 2 years
seen 17 hours ago

2d
comment sqlcmd returning NUL instead of NULL for tinyint column
So is there a way to make it NULL instead of NUL? Not that it matters anymore, but I'm still curious.
Jul
25
comment sqlcmd returning NUL instead of NULL for tinyint column
ypercube, I don't believe so since every other column that has NULL values is displayed correctly as NULL. It's only this one column.
Jul
25
comment sqlcmd returning NUL instead of NULL for tinyint column
I ended up using a Powershell script to get rid of the NULL and NUL values since I was going to BULK INSERT the results back into a table. Ex: (get-content $FILE) | foreach-object {$_ -replace ",NUL[L]*", ","} | set-content $FILE
Jul
25
asked sqlcmd returning NUL instead of NULL for tinyint column
Jul
22
accepted Can you upgrade a single SQL Server 2008 Failover Cluster Instance to SQL Server 2012?
Jul
22
answered Can you upgrade a single SQL Server 2008 Failover Cluster Instance to SQL Server 2012?
Jul
2
awarded  Curious
Jun
25
asked Complete Failover Cluster Failure SQL Server 2012
Jun
20
awarded  Notable Question
Jun
14
awarded  Self-Learner
Jun
13
awarded  Teacher
Jun
13
answered Table Data Space Used Confusion
Jun
13
comment Table Data Space Used Confusion
I think I'll be okay. 6 records get inserted every minute, I did use the SMALLDATETIME in the clustered index. Table is now 13MB from nearly 4GB.
Jun
13
comment Table Data Space Used Confusion
I believe I've found the issue. This is a HEAP table and has records inserted into it every minute. This results in massive fragmentation that is not recoverable. Correct? I just need to add a clustered index and defragment.
Jun
13
comment Table Data Space Used Confusion
Thomas Stringer: 492145 pages vs only 3563 on the table I did a SELECT * INTO of this data.
Jun
13
comment Table Data Space Used Confusion
David Spillett: I'm using Object Explorer 'Data Space Used' column, though I also have a query that looks at the sys.allocation_units table and it's reporting the same sizes.
Jun
13
revised Table Data Space Used Confusion
added 120 characters in body
Jun
13
asked Table Data Space Used Confusion
Jun
13
comment Can you upgrade a single SQL Server 2008 Failover Cluster Instance to SQL Server 2012?
We are getting a 3 node cluster to test this with shortly, possibly next week. I will make sure I post the results.
Jun
5
revised Can you upgrade a single SQL Server 2008 Failover Cluster Instance to SQL Server 2012?
added 257 characters in body